You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how to insert x-y axis chart, as opposed to category table

trying to create a chart with date on x-axis using following sheet:


chart created gives equally spaced points on x-axis for each datum in rows 2 through 11.

how/where can I choose a chart that will give me x-axis of full range of calendar dates, display price at corresponding date?


Posted on Aug 5, 2023 7:47 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 5, 2023 12:26 PM

So the essential points.


  • Don't use a Header Column for the dates.


  • Select the two columns and insert a 2D Scatter chart.


  • Click the series in the chart and in the Style tab at the right choose straight or curved Connection Lines.


Continue to format to taste.


SG



Similar questions

4 replies

Aug 5, 2023 9:41 AM in response to SaltSeaShark

Numbers makes two types of chart. Most of the listed types, including the one you have chosen,

are 'Category Charts' and chart a collection of values against a number of Categories.


Categories are spaced equally along the Category axis (horizontal, in your example)

Values are indicated by the height of each value above the category axis.


The second type, a Scatter chart, has two value axes; an x axis (horizontal) and a y axis (vertical). each data point displays the x value and the related y value, using the distance from that values axis.


While the value labels along each axis are evenly spaced, the data points being charted are not necessarily placed at those label positions.


Replacing your Line Chart with an XY scatter chart wll provide the display you want. Dates (the x values) labels may not include all of the dates, and will be equally spaced (as will the price labels on the Y axis) but the individual data points will not be restricted to alignment with those labels (as they are on the Category chart shown in your example), but will be detemined by the data itself (as the prices are on your table).


Regards,

Barry



PS: Category charts require the Categories be entered in a Header Column or Header Row and data Values to be entered in a non-header column or row.


Scatter charts require X and Y data values to be entered in non-header columns with paired X and Y values entered in the same rows.


B.


how to insert x-y axis chart, as opposed to category table

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.