# How to create a bar chart with percentage of percentage

1. ## 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  Register To Reply

2. ## 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?  Register To Reply

3. ## 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  Register To Reply

4. ## 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.  Register To Reply

5. ## Re: How to create a bar chart with percentage of percentage

The first chart below is after I made the suggestions

However the 2nd chart is how I want the chart to look  Register To Reply

6. ## 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.  Register To Reply

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