Sub-categories on the X axis
 

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.

Sub-categories on the X axis
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
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.

Sub-categories on the X axis
 

Hi Jon.

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
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.

Sub-categories on the X axis
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
Hi Jon.

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
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.

Sub-categories on the X axis
 

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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
Hi Jon.

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
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.

Sub-categories on the X axis
 

Everything's easy, when you know how.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in message
...
Hi Jon.

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"PBISMaryland" wrote in
message
...
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.