Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i build a stacked bar graph with three variables? claryal Charts and Charting in Excel 3 April 14th 23 05:32 PM
stacked bar graphs Dixie Charts and Charting in Excel 1 January 19th 06 09:10 PM
Variables and graphs teepee Excel Discussion (Misc queries) 7 January 3rd 06 12:47 AM
Vary variables in a formula via reference to another cell Peter Excel Discussion (Misc queries) 2 July 21st 05 07:19 PM
Fill array with fn variables that vary across and down? Llurker Excel Worksheet Functions 3 May 29th 05 02:27 AM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"