Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: How to create a Cluster columns Chart with stacked colums?

  1. #1
    Join Date
    27th July 2004
    Location
    Vancouver
    Posts
    4

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by cytop; July 14th, 2011 at 01:34. Reason: Removed outdated link

    Cheers
    Andy


  3. #3
    Join Date
    31st March 2007
    Location
    Massachusetts USA
    Posts
    63

    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/
    _______

  4. #4
    Join Date
    31st March 2007
    Location
    Massachusetts USA
    Posts
    63

    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/
    _______

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Create Stacked Column Chart
    By mohanprasadgutta in forum EXCEL HELP
    Replies: 1
    Last Post: August 2nd, 2008, 06:20
  2. Create Stacked Bar Chart/Graph
    By Maqbool in forum EXCEL HELP
    Replies: 5
    Last Post: May 30th, 2008, 19:47
  3. Stacked Chart With Double Columns
    By bluebells in forum EXCEL HELP
    Replies: 6
    Last Post: October 30th, 2006, 21:32
  4. Column/Stacked Columns Chart
    By DrewBe in forum EXCEL HELP
    Replies: 1
    Last Post: November 29th, 2005, 17:40
  5. cluster and stacked graph
    By james gibney in forum EXCEL HELP
    Replies: 1
    Last Post: November 23rd, 2004, 02:32

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
  •  
porno