Uncheck "Show Values" using the pop-up menu for Value Axis (Y1)Ĭheck "Show Axis" using the pop-up menu for Value Axis (Y2) With ther chart selected, open the Chart Inspector. To create the chart, select columns C and D, then click the Charts button and select the Two-Axis chart. To provide the second 'data' set, I've added column C, and filled it with zeroes. As 'categories', they will be evenly spaced along the x axis, and wil be ordered left to right in the order they appear (top to bottom) in column A of the table.Ģ-Axis charts require a table with two columns of Y data. The data columns are column B (X values) and column D (Y values).īecause this is a Category chart, the X values must be listed in a header row, where they will be recognized as 'category labels'. The two (Y) axes may have different scales, and may be formatted separately. ![]() ![]() ![]() It's the last one on the menu in the Charts button, requires two series of Y values, and defauts to a line chart for the first series and a column chart (vertical bar chart) for the second Y series. Ian's suggestionis the only one I know using a scatter chart, but Numbers also offers a '2-axis' Category chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |