Announcement

Collapse
No announcement yet.

How to create a Cluster columns Chart with stacked colums?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to create a Cluster columns Chart with stacked colums?

    I have been wondering for a long time how to create a chart that has a bunch of variables and is presented in Cluster Columns graph formating, but at the same time the main variables on the grahp are split into sub categories using stacked column graph formating.

    I tend not to use this too often because I have not found a way to do it in a single chart all together. What I usually do "IF I HAVE TO" is to combine to graphs and start playing with the formating until it looks like a single chart. The problem is that it is very time consiuming and to update is also very time consuming.

    Here is and example of the problem I face, and the solution I use.

    Thanks for you help!
    Attached Files

  • #2
    Hi juanb77,

    With a little bit of data layout manipulation and an extra data series to tidyup the xaxis you can do it in one chart.

    If you need pointers on how to re create the chart check out this link.
    http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

    If you have any other questions post back

    *EDIT* - See next post.
    Attached Files
    Last edited by cytop; July 14th, 2011, 01:34. Reason: Removed outdated link

    Cheers
    Andy

    Comment


    • #3
      Re: How to create a Cluster columns Chart with stacked colums?

      I know this is an very old thread, but people still follow it to the link Andy posted on my web site.

      I've updated the Clustered-Stacked Column Chart article, and it's now named Clustered-Stacked Column Charts.
      - Jon
      -------
      Jon Peltier, Microsoft Excel MVP
      Peltier Technical Services, Inc.
      http://PeltierTech.com/WordPress/
      _______

      Comment


      • #4
        Re: How to create a Cluster columns Chart with stacked colums?

        The article that Andy linked to has been updated and relocated. The new name and link are Clustered-Stacked Column Charts.
        - Jon
        -------
        Jon Peltier, Microsoft Excel MVP
        Peltier Technical Services, Inc.
        http://PeltierTech.com/WordPress/
        _______

        Comment

        Working...
        X