Format Axis - Time

[Kevin Stecyk]

Hi,

Using XL 2003.

I have a workbook with 3 graphs. Two of the graphs are correct and they
both source their data off of a particular worksheet. The third graph is
giving me grief as I am not able to have its X-Axis show as time. It
sources its data from a different sheet.

When I Format Axis, I expect to see

Time (X) axis scale
Minimum
Maximum
Base Unit
Major Unit
Minor Unit
Value (Y)
blah blah...

Instead I get the following:
Value (X) axis scale
Minimum
Maximum
Base Unit
Major Unit
Minor Unit
Value (Y)

I am missing the base unit. The source data is DEFINITELY a date as I have
formatted as such. I have also tried custom format dd.mmm.yyyy. No luck in
changing the Format Axis.

I want the major increments to be a single month. But without being able to
get the Time (X) axis scale, I am out of luck.

Any words of wisdom?

Best regards,
Kevin

 

[Jon Peltier]

Kevin -

I assume by "I am missing the base unit" that you don't have Base Unit
(you show it in your list of parameters).

Sounds like you have two Line charts with time-scale (really date-scale)
axes, and one XY Scatter chart with a value axis. Right click the chart,
choose chart type, and pick out one of the Line styles.

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

 

[Kevin H. Stecyk]

Hi Jon,

I assume by "I am missing the base unit" that you don't have Base Unit
(you show it in your list of parameters).
Correct.

Sounds like you have two Line charts with time-scale (really date-scale)
axes, and one XY Scatter chart with a value axis. Right click the chart,
choose chart type, and pick out one of the Line styles.

Yes, that fixed it. Thank you so much!

Best regards,
Kevin