Stacked Column Chart - Total that isn't the sum of series

A

Alissa

Hello!

I need to create a stacked column chart that totals to a percentage that
isn't the sum of the 2 series which make up the stacked column. For example,
I need to show a person has a 10% error ratio. Within that 10%, i need to
show that 40% were one type of error and 60% was another type of error, but i
want the column to total to 10%, not 100%.

Any help would be fantastic! Thank you!
 
A

Andy Pope

Hi,

You would need to calculate new chart values from the data you already have.

The 2 chart values would be 10%*40% and 10%*60%

This will then display a stacked column totaling 10% split 40/60.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total of Stacked Column Chart 1
Combo Stacked column/column/line 1
Stacked Columns with different series in each column 0
Stacked Chart (per month per year) 1
Stacked Column Chart 2
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Show total in a Stacked Chart 1
Problem with stacked column chart 5

Top