+ Reply to Thread
Results 1 to 6 of 6

How to create a bar chart with percentage of percentage

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    6

    How to create a bar chart with percentage of percentage

    Hello, I am trying to make a chart from the percentages columns of this main table

    Table1.JPG

    Just focusing on percentages

    Table2.JPG

    I am trying to make a bar chart where the column Number of Males > 60 % will represent the inside the column Number of Males %

    So for example the first record, I want to see 36% as the main bar and then that bar should be filled upto 57% with Number of Males > 60 % value but instead I get them stacked one on top of each other

    Chart.JPG

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

    Re: How to create a bar chart with percentage of percentage

    How much of this is actual chart creation, and how much is getting the right data in the spreadsheet? If you are able to create a stacked column chart, I am guessing that the problem isn't with how to create a chart, but how to get the right data in the spreadsheet.

    If I understand what you want, you need to calculate the correct value for each "stack" in the stacked column chart. Assuming I understand the desired calculation, you need to add a column that will calculate 0.57*0.36 in one column, then 1-0.57*0.36 in a second column. Assuming this is in your first picture and that A1 is the upper left cell, this could be =PRODUCT(E2:F2) in G2 and H2 would then be =1-G2 (copy/paste/fill down as far as needed). Then use these two column for your stacked column chart.

    Did I understand you correctly?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    07-22-2013
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: How to create a bar chart with percentage of percentage

    Unfortunately that distorts the results into below chart

    Attachment 771479

    I tried to demo this in mspaint to clarify how exactly I want to represent

    Attachment 771480

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

    Re: How to create a bar chart with percentage of percentage

    Your latest attachments failed to attach. Be sure to follow instructions in the yellow banner at the top of the page.

    I'm not sure how the results are distorted, but I would guess that that means that I guessed wrong as far as the calculation. The chart itself will show the numbers that are in the spreadsheet. If the chart looks distorted, then the numbers in the sheet are incorrect. The overall idea should work, just replace my calculations with the correct calculations.

  5. #5
    Registered User
    Join Date
    07-22-2013
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: How to create a bar chart with percentage of percentage

    Reuploading

    The first chart below is after I made the suggestions

    However the 2nd chart is how I want the chart to look
    Attached Images Attached Images
    Last edited by sid86; 03-07-2022 at 09:33 PM.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: How to create a bar chart with percentage of percentage

    Calculate the percentage values, including a repercentage for the smaller column.

    For that series use data labels linked to the correct % value.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 6
    Last Post: 02-08-2022, 07:27 AM
  2. Replies: 0
    Last Post: 05-13-2019, 08:08 PM
  3. Deducting percentage, calculate what percentage needs to be added to reverse
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2019, 05:47 AM
  4. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  5. [SOLVED] Formula for percentage Increase and corresponding percentage decrease (and viceversa)
    By jcroque89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2015, 10:25 AM
  6. Showing a percentage of a percentage in pie chart
    By jimbob76 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-17-2009, 09:52 AM
  7. Replies: 1
    Last Post: 10-28-2005, 01:05 AM

Tags for this Thread

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