Graph 2 x-axes: one for years, one for months

[hstaubyn]

Hi,

I have some data that is organised by years and months. I am trying to create a graph that has two x-axes. I would like the bottom one to show years, and the one just above it to show months.

Does anyione know how to create two axes and have them produce the above results?

Thanks,

H

 

[Andrew Poulsom]

You can enable a secondary x axis when you add a secodary y axis:

http://www.andypope.info/tips/tip008.htm

 

[energman58]

If you format your data correctly it will do it automatically I think (at least with 2007 and 2010)

See here for details:

http://excel.tips.net/Pages/T003203_TwoLevel_Axis_Labels.html

Its in Axis Options as Multi Level Axis or some such words

 

[hstaubyn]

Thanks energman 58, that link provided the perfect answer.

Quite simple really.