+ Reply to Thread
Results 1 to 2 of 2

Help showing multiple percentages on a stacked column

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    Berkeley, CA
    MS-Off Ver
    Excel for Mac 16.16
    Posts
    1

    Help showing multiple percentages on a stacked column

    Hi there,

    I'd like to show 3 percentages. A large column at 100%, an overlying column of 44% and another overlying column of smaller width at 32%. I've tried several tutorials without success.

    Any help would be appreciated. I've included a sketch of what I'd like below. I don't have raw data to do this with so maybe the answer is how I portray the data.

    Thanks!



    example.png
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,543

    Re: Help showing multiple percentages on a stacked column

    Here's how I would expect to do it:

    1) Enter data in the spreadsheet. In A1, enter 0.32, In A2, enter 0.44, In A3 enter 0.56 (1-0.44).
    2) Select A1:A3 -> Insert -> Column Chart -> Stacked column chart. Excel will default to series in columns, so you will get three separate columns.
    3) Execute "switch rows/columns". Now you have one stacked column with three parts.
    4) Select series 1 (the 0.32 series)-> format series -> move to secondary axis. Set gap width to something larger (250% or whatever suits your fancy).
    5) Select the primary vertical axis -> format axis -> set min and max limits to 0 and 1. Repeat for secondary vertical axis.

    That should be close to what you show in your pictures.
    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. [SOLVED] Percentages Wrong in 100% Stacked Column
    By bwhi in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2018, 12:54 PM
  2. Replies: 1
    Last Post: 06-13-2017, 12:32 PM
  3. Replies: 2
    Last Post: 04-22-2016, 05:25 PM
  4. My stacked column Bar chart is not showing the right data!
    By JamesR12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-14-2013, 07:11 AM
  5. Stacked Column Chart showing the Limits
    By rose4emi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 04:15 AM
  6. Replies: 0
    Last Post: 03-02-2012, 12:54 PM
  7. stacked bar chart with percentages
    By name in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-21-2006, 09:28 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