Results 1 to 2 of 2

Side-by-side stacked bar chart (with a secondary axis)

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 ...

  1. #1
    DMT
    DMT is offline
    New Member
    Join Date
    Jan 2004
    Posts
    28

    Default Side-by-side stacked bar chart (with a secondary axis)

    Hi,

    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.
    Thanks.

  2. #2
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550

    Default Re: Side-by-side stacked bar chart (with a secondary axis)

    Andy Pope has some excellent examples:

    http://andypope.info/charts/stackside.htm

    Or see Jon Peltier

    http://peltiertech.com/Excel/Charts/...StakAboveBelow

    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)

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com