measuring plan in % with pie chart
 

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

measuring plan in % with pie chart
 

On Tue, 13 Nov 2007, in microsoft.public.excel.charting,
Mortir said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

measuring plan in % with pie chart
 

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 he

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

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

Or thermometer charts:

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

--
John Mansfield
http://cellmatrix.net





"Mortir" wrote:

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