Charting dates

[Terry]

I am creating a graph in Excel 2007 where there are multiple dates on the X
axis. By default Excel groups duplicte dates togeather on the axis. You can
have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.

Is there a way to this in Excel 2003?

Terry

 

[Jon Peltier]

Chart menu > Chart Options > Axes tab, change from Time Scale (or Automatic)
to Category.

- Jon

 

[Terry]

Thanx, works great

Chart menu > Chart Options > Axes tab, change from Time Scale (or
Automatic) to Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______