Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 22nd 07, 08:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
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  
Old October 22nd 07, 08:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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
news
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 2 October 15th 07 01:31 PM
stacked bar graphs Dixie Charts and Charting in Excel 1 January 19th 06 08:10 PM
Variables and graphs teepee Excel Discussion (Misc queries) 7 January 2nd 06 11:47 PM
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 08:05 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017