Apple Event: May 7th at 7 am PT
Couple of things. 1. I am wanting to change the X axis labels to reflect the date as it appears on the bottom table. 2. I am wanting to decrease the increments of the Y axis. I’ve been messing around with this for a few hours and I am defeated.
P.S. there is a hidden row on the table under date if that matters. (On iPhone)
If you have dates at uneven intervals then you probably should use a 2D Scatter Chart rather than a Line Chart.
Start with two columns in the table and make sure the left column is NOT a Header Column.
From you screenshot it looks as if you are on an iPad. Select the cells in the two columns in the table. Then tap Cell Actions... Create New Chart and choose the Scatter Chart (the one with the + s).
With chart selected tap the "Paintbrush" > General and one of the Connection Lines. The chart will now look more like a "line" chart.
To change the intervals on the Y Axis you can then Tap 'Data' > Y Axis Scale and vary the number of Steps.
If you continue to have trouble with charts start a new document based on 'Charting Basics' under the Basic category (scroll to the right to see it) and study the examples there.
SG
If you have dates at uneven intervals then you probably should use a 2D Scatter Chart rather than a Line Chart.
Start with two columns in the table and make sure the left column is NOT a Header Column.
From you screenshot it looks as if you are on an iPad. Select the cells in the two columns in the table. Then tap Cell Actions... Create New Chart and choose the Scatter Chart (the one with the + s).
With chart selected tap the "Paintbrush" > General and one of the Connection Lines. The chart will now look more like a "line" chart.
To change the intervals on the Y Axis you can then Tap 'Data' > Y Axis Scale and vary the number of Steps.
If you continue to have trouble with charts start a new document based on 'Charting Basics' under the Basic category (scroll to the right to see it) and study the examples there.
SG
Adding a note to SG's response:
The huge numbers on the Y axis, and the blue line running across the top of the chart appear to be caused by the chart reading the dates in column A as data, converting each date to a serial number counting the days since January 1, 1904, and plotting the data point for the Untitled n category at that height on the graph.
On a Line chart, the category names need to be in a Header column (or Header row). Not having a Header column in the table explains the "Untitled" category labels on the horizontal axis.
When you delete the current Line Chart, and replace it with the suggested x-y scatter chart, using the same two columns of data, the dates will be interpreted as dates and will become the x datum for each pair; the amounts will become the y datum, and the x and y axes will be better scaled to fit the 'unconverted' date data and the unchanged amount data, allowing the viewer to actually perceive the slope of the lines connecting the data points.
Regards,
Barry
Thank you so much! That was a super easy solution. Much appreciated!
Numbers line graph
