View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
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