Hi,
Remove the 'Year' and 'Month' text from the 2 cells and then select and
use the chart wizard. It should then use the first 2 columns as the x
axis category labels and plot 2 series #start and #end.
Cheers
Andy
> So I have data like this:
>
[quoted text clipped - 13 lines]
>
> Thanks.

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
kramer.newsreader@gmail.com - 10 Oct 2006 20:52 GMT
So then is there a way to plot the x axis using the dates rather then
just the row number?
> Hi,
>
[quoted text clipped - 22 lines]
> >
> > Thanks.
Andy Pope - 10 Oct 2006 21:04 GMT
If you do as suggested your x axis should look like this.
+------+------+-----+-----+
1 2 3 4
2001 2001 2001 2001
Are those cells dates? I think the chart will only take a date from 1
set of cells.
Cheers
Andy
> So then is there a way to plot the x axis using the dates rather then
> just the row number?
[quoted text clipped - 25 lines]
>>>
>>>Thanks.

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info