Help with "base unit" in chart axis

[Marc Reinig]

I have two charts. In one, when I go to "format axis" I can enter the min
and max scale as dates and the entry remains as dates when I come back. I
can also set the "base unit" a major and minor grid line in days, weeks,
months, etc.

The second chart, I do not have a base unit drop down box, and although I
can enter dates in the max and min in date format and they work, when I come
back the entries are in days since the start of time (38353 in 1/1/2005)
And I cannot specify the units of major and minor grid lines, they are just
units. Which makes it awkward for minor girdlines on months.

I have looked all over the place and can't figure out how to change the
second spread sheet to act like the first.

Thanks in advance,

Marc Reinig
System Solutions

 

[Jon Peltier]

Marc -

The first chart is a Line chart, which has a time scale X axis. The
second is an XY Scatter chart, which has a value X axis.

Select the second chart (the entire chart, not just one series), choose
Chart Type from the Chart menu, and select an appropriate Line chart
type and subtype.

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