How do I show a bigger gap between non equadistant dates in Excel

[Grace Poole]

I am so frustrated! I am trying to enter data that has 3 different dates not
equally distant and want to show on the associated chart that there is a
bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can
anyone please help.

 

[Barb Reinhardt]

If you have a BAR chart, I'd suggest this. Let's say you have data for
1/05, 3/05 and 8/05. Why not have X labels for 1/05, 2/05, 3/05, 4/05, ...
8/05, but only enter Y values for the months of interest.

If you have a LINE chart, why not change it to XY Scatter.

 

[Tushar Mehta]

Convert the x-axis to a 'time scale.' Select the chart, then select
Chart | Chart Options... | Axes tab. In there, set the Category (X)
axis to 'Time-scale'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Make sure that the values are interpreted by Excel as numerical dates, and
not just labels. Normally if Excel recognizes dates in the category range,
it will automatically select the time scale axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______