+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    06-13-2007
    Posts
    2

    "Paired" stack column charts

    All,

    am creating stacked charts with a number of categories' data. I have 5 rows of data. For each month, I want to see two stacked columns (i.e. a stacked column with 3 rows of data, followed by a separate stack with the remaining two rows of data - only in the same chart)

    Using a normal stacked chart - by adding series, the remaining two rows of data are added to the first stack, thus creating a single stack with 5 constituent sets of data.

    Could anyone help? Does this make sense?

    Thanks, in advance,
    bardo

  2. #2
    Forum Guru
    Join Date
    03-13-2005
    Posts
    6,199
    Quote Originally Posted by bardo
    All,

    am creating stacked charts with a number of categories' data. I have 5 rows of data. For each month, I want to see two stacked columns (i.e. a stacked column with 3 rows of data, followed by a separate stack with the remaining two rows of data - only in the same chart)

    Using a normal stacked chart - by adding series, the remaining two rows of data are added to the first stack, thus creating a single stack with 5 constituent sets of data.

    Could anyone help? Does this make sense?

    Thanks, in advance,
    bardo
    Hi,

    not 100%, but perhaps a look at some of Andy Pope's charts might help, firstly try http://www.andypope.info/charts/stackside.htm

    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    06-13-2007
    Posts
    2
    Thanks - those have definitely helped (and impressed my boss at the same time )

    Cheers,
    bardo

  4. #4
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130
    Adding to Brian's, here's another to take a look at and impress your Boss even more

    http://peltiertech.com/Excel/Charts/StackedCharts.html

    http://peltiertech.com/Excel/Charts/...eAndBelow.html
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0