If you want to show several year's data, month by month, put the data
into a columnar format like so:

--- 2007 2008 2009 2010
Jan xx xx xx xx
Feb xx xx xx xx
Mar xx xx xx
etc.

The top left cell in the table (denoted by ---) should be completely blank.

Select this range and make your chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/22/2010 3:06 PM, nwp wrote:
I am trying to create a chart that will allow me to have multiple years on
the same chart so the difference can be seen from year to year.

Second problem is there a limit to what can be entered into the axis.

I'm not sure if this is clear or not.

Appreciate any assistance.