I want to display months and years on x axis
 

I have a spreadsheet with quarterly Forecast, Sales and Difference for three
years.
The assignment I am doing requires me to show the quarters on the x axis
(1,2,3,4,1,2,3,4,1,2,3,4) but below the quarters I must also show the three
years on the x axis (1,2,3). I can't seem to work out how to display the two
range of fields.


Michael

I want to display months and years on x axis
 

Hi,

You can include an extra column of labels in your chart data.
Create a chart on the range A1:C13

C1: =SeriesName
A2:=Qrt 1 B2: =1 C2: =1
B3: =2 C3: =2
B4: =3 C4: =3
B5: =4 C5: =2
A6: =Qrt 2 B6: =1 C6: =1
B7: =2 C7: =2
B8: =3 C8: =3
B9: =4 C9: =2
A10: =Qrt 3 B10: =1 C10: =1
B11: =2 C11: =2
B12: =3 C12: =3
B13: =4 C13: =1

Hopefully the tabbing layout remains readable.

Cheers
Andy

Michael Drayton wrote:
I have a spreadsheet with quarterly Forecast, Sales and Difference for three
years.
The assignment I am doing requires me to show the quarters on the x axis
(1,2,3,4,1,2,3,4,1,2,3,4) but below the quarters I must also show the three
years on the x axis (1,2,3). I can't seem to work out how to display the two
range of fields.


Michael

--

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