Scatter chart

Question

Level 1

4 points

Scatter chart

Hello. Is there any way I can customize the x axis steps in my scatter plot so it only shows 2 days of the week every week? I want the x axis on the scatter plot to reflect only Tuesday’s and Friday's as shown in the table.

iPhone 11 Pro Max, iOS 14

Posted on May 28, 2021 6:59 AM

Reply

Answer 1

SGIII

Level 8

37,774 points

May 28, 2021 7:46 AM in response to Numbersrook

Perhaps you could use a 2D Line Chart instead of a 2D Scatter Chart:

You can remove connection lines and do other stying by clicking the series in the chart and going to the Style tab:

SG

Reply

Answer 2

Numbersrook Author

Level 1

4 points

Jun 3, 2021 5:31 AM in response to SGIII

So when I try the line graph instead of a scatter. The results turn out like this. Straight across oppose to up and down like a line graph should be.

Reply

Answer 3

Badunit

Level 7

31,192 points

Jun 3, 2021 6:29 AM in response to Numbersrook

When you selected the X and Y data for the line chart it saw it as two series, not as X and Y. Line charts should have the X axis categories in a header column, that is what Numbers prefers. When creating a line chart you only select the Y data and it uses the values in the header as the X axis. Scatter charts, on the other hand, want X and Y to NOT be in header columns and you select both to make the chart.

If you are okay with converting the first column to a header column:

If the dates are in column A, convert it to a header column.
Select the Y values in column B and make your chart.

If you do not want to convert A to a header column:

Select only the Y values and make your chart.
Click on the chart and go to the formatting sidebar, to the Axis tab and then to the X axis
Where it says "label references", delete anything that is there then go to your table and select the cells that have your X axis data. This will make them the "label references" on the X axis.

Reply