Sub-categories on the X axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Hi Jon.

I am using 2003 but the school name repeats under each school year and I do
not want that.
Thanks.
 
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
 
That did it. I feel silly that I didn't figure that out but that's why there
are people like you.

Thanks again.
 
Back
Top