| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
| Are Pivot Charts only useful with limited number of categories(x-axis)? | Charts and Charting in Excel | |||
| Sub-Categories for X-axis labels, line on bar chart? | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| how do I get the x-axis to plot values rather than categories in . | Charts and Charting in Excel | |||
Linear Mode
