measuring plan in % with pie chart

[Mortir]

I d like to measure how much of my plan has been succeeded... lets say
5% OF 100%, later this would rise to 50% and so on. The problem i now
have is how to present a PIE chart after I go beyond 100% if I do
better than the original plan is? any idea? thanks for all the help

 

[Del Cotter]

I d like to measure how much of my plan has been succeeded... lets say
5% OF 100%, later this would rise to 50% and so on. The problem i now
have is how to present a PIE chart after I go beyond 100% if I do
better than the original plan is?

You can't, it's impossible. I recommend using a bar chart instead.

 

[John Mansfield]

Given the way pie charts work, you're not going to be able to go past 100%.
Another idea would be to use a bar chart instead of a pie chart. You could
try average line charts which are illustrated here:

http://www.andypope.info/charts/averageline.htm

http://peltiertech.com/Excel/Charts/AddLine.html

Or thermometer charts:

http://www.andypope.info/charts/thermometer.htm