+ Reply to Thread
Results 1 to 6 of 6

Clustered and Stacked column in the same chart

  1. #1
    Forum Contributor
    Join Date
    10-18-2012
    Location
    ardeduck schools
    MS-Off Ver
    Excel 2003
    Posts
    100

    Clustered and Stacked column in the same chart

    Hi I'd like to separate 1 column and combine 2 others.

    For example in this file I'd like the blue column to be alone and the to others merged
    https://docs.google.com/file/d/0B1XY...it?usp=sharing

    Can somebody help?

    Regards,

    Bryan

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Clustered and Stacked column in the same chart

    you can use a dummy series, a secondary axis and adjust the gap width and overlap settings to get the appearance you want
    Attached Files Attached Files
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    10-18-2012
    Location
    ardeduck schools
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: Clustered and Stacked column in the same chart

    Ohh thanks a lot!
    How did you do that??
    THanks again!!

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Clustered and Stacked column in the same chart

    I formatted the second two series to plot on the secondary axis, then changed their chart type to stacked column
    I added a dummy blank series to the first axis for spacing
    I adjusted the gap width of the series until they spaced properly
    Then I adjusted the axis scales so they both matched each other and finally deleted the legend entry for the dummy series

    as best I remember ;-)

  5. #5
    Forum Contributor
    Join Date
    10-18-2012
    Location
    ardeduck schools
    MS-Off Ver
    Excel 2003
    Posts
    100

    Re: Clustered and Stacked column in the same chart

    Perfect thanks a lot!!

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Clustered and Stacked column in the same chart

    you're welcome :-)

    please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clustered and Stacked Column Chart
    By superkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-19-2009, 09:54 AM
  2. [SOLVED] Combined: Clustered-Stacked Column Chart
    By cdo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2005, 09:05 PM
  3. Can I combine a stacked and clustered column chart in Excel
    By Tim Donnelly in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-07-2005, 11:06 AM
  4. [SOLVED] combination clustered column and stacked bar chart
    By John in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-19-2005, 11:06 AM
  5. Clustered column chart with stacked coumns
    By Dave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-04-2005, 07:06 PM

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.6.0 RC 1