View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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!