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

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!

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Alissa" wrote in message
...
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!