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

Question:

Question: Can I vary the space between a chart's dates?

I have a Numbers sheet where I have dates in column A, numeric values in B. When I plot those in a chart, the dates appear as X-axis values such that the space between the 2nd and 3rd is the same as between, say, the 3rd and the 15th.


Is there a way to make the space between the dates variable? I have a feeling I simply must have all the days in column A for the range I need.


Thanks.

MacBook Pro with Retina display, macOS High Sierra (10.13.3), 16 GB

Posted on

Reply

Feb 28, 2018 11:48 AM in response to Tim Murray2 In response to Tim Murray2

Hi Tim,


Column A on your table is a Header Column, and your chart is a Category chart. Each 'category' is given equal space on the Category Axis.


You need to place the Dates in a non-header column so they may be treated as Data, not category labels.


Click on any cell in column B, then press option-left arrow to insert a new non-header column between B (now C) and A.

Click on (the new) B2 to select it, type = to open the formula editor, then click on A2, then click the green checkmark to confirm the formula.

Fill the formula down column B to the last row containing a date in column A.This will also select all cells containing the formula.

With these cells selected, Copy, then go Edit (menu) > Paste Formula Results to replace the formulas with the dates that were copied from column A.

Format the selected cells as Date & Time, with Date set to display as you want it and Time set to none.

Select column A and go Table > Delete column.


Select columns A and B, then go to the Charts button and choose x-y scatter graph.

Format as desired.


Regards,

Barry

Feb 28, 2018 11:48 AM

Reply Helpful
User profile for user: Tim Murray2

Question: Can I vary the space between a chart's dates?