+ Reply to Thread
Results 1 to 4 of 4

Creating Two Column Stacked Graphs Next to Each Other

  1. #1
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    211

    Creating Two Column Stacked Graphs Next to Each Other

    Hi

    Can someone please advise the best way to do this?

    Perhaps someone already has a template

    I have attached an example.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Creating Two Column Stacked Graphs Next to Each Other

    There is way to do it, but it would be somewhat convoluted.

    1. Select A2, B2, D2. Create column chart.
    2. Select A2, C2, E2. Create column chart.

    Copy 2nd chart. Select chart area of first chart and paste. Change chart type to stacked column.

    Adjust data label as needed (Image below used Value from Cells concatenated with Value).
    1.JPG

    There may be a better method. But it eludes me.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    10-09-2010
    Location
    London
    MS-Off Ver
    Excel Version Office 365
    Posts
    211

    Re: Creating Two Column Stacked Graphs Next to Each Other

    Thank you for the advice.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Creating Two Column Stacked Graphs Next to Each Other

    The easiest procedure I know for a "clustered and stacked" column chart is this one: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that most of the work is arranging the data in the spreadsheet. With the data properly arranged, the chart is a basic stacked column chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Excel 2007 : Stacked and Clustered Column Graphs
    By sckrmccfo in forum Excel General
    Replies: 0
    Last Post: 05-07-2012, 03:03 PM
  2. Combining Cluster Column Bar graphs and Stacked Columns
    By sweetrice80 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-11-2010, 08:54 AM
  3. 2 stacked column graphs?
    By kjlorfeld in forum Excel General
    Replies: 1
    Last Post: 04-20-2007, 02:59 PM
  4. Creating stacked graphs side-by-side
    By yssem in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-14-2006, 07:18 AM
  5. Stacked Column graphs reflecting net totals
    By KH in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-28-2006, 04:10 PM
  6. [SOLVED] How do I combine stacked column and single column graphs?
    By Alf in forum Excel General
    Replies: 0
    Last Post: 02-23-2006, 08:35 PM
  7. [SOLVED] How do I create two stacked column graphs together?
    By Sarath GS in forum Excel General
    Replies: 5
    Last Post: 07-08-2005, 07:05 AM

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