Sub-categories on the X axis

[PBISMaryland]

I am trying to graph data from various schools and want to display data from
2002-03, 2003-04, 2004-05 and so on with the school name under that range of
dates. I only want the school name to appear once. The data adjacent to
those dates had the school name repeated for each year but when I merge the
repeated school names into one field the chart now show only one school name
but it is directly under the first data point. I want it to be centered
under the dates associated with that particular school.
Thanks for your help.

 

[Jon Peltier]

What version of Excel? In 97 the behavior was as you describe (if I
understand it) but in 2000, 2002, and 2003 (and I believe 2007) the single
label is centered below the included categories.

- Jon

 

[PBISMaryland]

Hi Jon.

I am using 2003 but the school name repeats under each school year and I do
not want that.
Thanks.

 

[Jon Peltier]

Set up the data like this. Any cells that look blank are really blank (no
formulas returning "" or anything, they are cleared out).

Value
Umass 2002-03 2
2003-04 3
2004-05 4
2005-06 5
Uconn 2002-03 6
2003-04 7
2004-05 8
2005-06 9
URI 2002-03 10
2003-04 11
2004-05 12
2005-06 13

Select this range and create a chart. The school will be centered beneath
the range of years.

- Jon

 

[PBISMaryland]

That did it. I feel silly that I didn't figure that out but that's why there
are people like you.

Thanks again.

 

[Jon Peltier]

Everything's easy, when you know how.

- Jon