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!