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

Sorting a stacked column 0
sideways stacked bar charts with line series on the same axis 0
Total of Stacked Column Chart 1
Combo Stacked column/column/line 1
Doughnut Chart linked with the slicer in the pivot table 0
Amending meeting cancels all future meetings 0
Stacked Bar Chart 1
Problem with stacked column chart 5

Top