This is a discussion on Side-by-side stacked bar chart (with a secondary axis) within the Excel Questions forums, part of the Question Forums category; Hi, Is it possible to do side-by-side stacked bar charts? Here is some data as an example. Let's say I ...
Is it possible to do side-by-side stacked bar charts? Here is some data as an example. Let's say I want the number of apples and oranges picked in each year. There are two types of apples and two types of oranges. So in Year 1, there are 100 green apples and 50 red; and in year 2 there are 90 green and 60 red. For the oranges, in Year 1 there are 1000 mandarin and 2000 navel; and in Year 2 there are 1100 mandarin and 2200 navel. Now the other issue I have is, I would like the "apple" series to be on a different scale from the "oranges" because so many more oranges were picked.
I hope I was clear enough.
Andy Pope has some excellent examples:
Or see Jon Peltier
Or get a copy of John Walkenbach's book, Excel Charts - a valuable investment.
- old, slow, and confused
... but at least I'm inconsistent -
(retired Excel 2003 user, 3.28.2008)