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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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/
_______
 
Back
Top