Share via

Chart Axis - Discontinuous Range

Anonymous
2010-11-15T14:57:28+00:00

Hi.

I have a chart which on the x axis has a series of dates.  In the data source these dates do not run consecutively (i.e. there is no data for weekends), however, when I create the chart the missing dates are added onto the access (albeit with no data).

Does anyone know why excel is adding these dates in and/or how to make it just use the information contained in the data table??

Thanks.

Elizabeth.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2010-11-15T15:57:29+00:00

Excel interprets the axis as a time axis. To change this:

  • Click once on the chart to select it.
  • Select Chart | Chart Options...
  • Activate the Axes tab.
  • Under Category (X) Axis, select Category instead of Automatic or Time Axis.
  • Click OK.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest