How can I get my chart to look like this? Image included!

[sp00nix]

I've attatched an image with the chart's X-axis labels i would like t
emulate.

My chart is the second chart in the image.

Thanks for you help!

[image: http://www.excelforum.com/attachment.php?s=&postid=618546]

Attachment filename: graphs.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=61854

 

[Jon Peltier]

If you're using Excel 2000 or later, just put the year in the first cell
where it would appear:

2002 1H
2H
2003 1H
Jun
Jul
Aug
Sep
Oct
Nov
Dec
2004 Jan
Feb
Mar

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

 

[sp00nix]

Hmm, no such luck. Do I have to do anything else special?

Here's what it gave me

Attachment filename: didntwork.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=61923

 

[Jon Peltier]

You need to use two columns of category labels, with the years in the
first column, and the months in the second.

The answer I provided works in Excel 2000+, BTW, but not in Excel 97.

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

 

[sp00nix]

Thank you very much! It's now working correctly