Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-4 stacked bar graphs, two variables each, Y's vary same chart
An example of what I want to do on one chart would be if I wanted to do bar
graphs of male and female attendance for 5 months for two or more classes. The X axes are all the same, with the categories of 5 months eg jan-May) . There would be two bars (male and female attendance) for each month on all of the graphs . The Y's might be different for each class. I want them all on the same chart. (I have spend 5 frustrating hours trying to figure out how to do this! I already have my data in separate charts, but have the source data). I shall be so grateful if someone can help me do this! -- Writer Seeking Clairty |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-4 stacked bar graphs, two variables each, Y's vary same chart
Set up the data like this, keep the top left cell blank, and populate the
range below the labels and right of the months: Class A-F Class A-M Class B-F Class B-M Jan Feb Mar etc. Create a column chart using series in columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Writer on Path" wrote in message ... An example of what I want to do on one chart would be if I wanted to do bar graphs of male and female attendance for 5 months for two or more classes. The X axes are all the same, with the categories of 5 months eg jan-May) . There would be two bars (male and female attendance) for each month on all of the graphs . The Y's might be different for each class. I want them all on the same chart. (I have spend 5 frustrating hours trying to figure out how to do this! I already have my data in separate charts, but have the source data). I shall be so grateful if someone can help me do this! -- Writer Seeking Clairty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i build a stacked bar graph with three variables? | Charts and Charting in Excel | |||
stacked bar graphs | Charts and Charting in Excel | |||
Variables and graphs | Excel Discussion (Misc queries) | |||
Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) | |||
Fill array with fn variables that vary across and down? | Excel Worksheet Functions |