Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 6th 06, 05:31 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default let me make multiple bar stack graphs in excel

I currently use Excel 2003 and would like to suggest a new choice for a chart
display. I would like compare data across years by looking at one stacked
bar next to another, i.e. to compare TWO or more stacked bars to each other.
The example is that I'm trying to display the number of positive results out
of the number of tests completed by month over time. I envision one stacked
bar (# positives w/in total tests performed) for month A in year 1 directly
next to a second stacked bar (# positives w/in total tests performed) for
month A in year 2, a second set of stacked bars for month B in years 1/2+ and
so on.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

  #2   Report Post  
Old October 6th 06, 06:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default let me make multiple bar stack graphs in excel

Teresa -

Is this what you want?

http://peltiertech.com/Excel/ChartsH...sterStack.html

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


"NJTeresa" wrote in message
...
I currently use Excel 2003 and would like to suggest a new choice for a
chart
display. I would like compare data across years by looking at one stacked
bar next to another, i.e. to compare TWO or more stacked bars to each
other.
The example is that I'm trying to display the number of positive results
out
of the number of tests completed by month over time. I envision one
stacked
bar (# positives w/in total tests performed) for month A in year 1
directly
next to a second stacked bar (# positives w/in total tests performed) for
month A in year 2, a second set of stacked bars for month B in years 1/2+
and
so on.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting





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
i need to know how do we make multiple bar chart in EXCEL msadiqh Excel Worksheet Functions 0 June 24th 06 10:59 AM
How to you open multiple versions of Excel buriedinit Excel Discussion (Misc queries) 1 June 21st 06 06:19 AM
Multiple Excel on Task bar Craig Excel Discussion (Misc queries) 3 September 9th 05 07:11 PM
graphs from multiple worksheet : query Lia Charts and Charting in Excel 1 January 8th 05 05:49 AM
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 3 December 1st 04 06:47 PM


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

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