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

On Tue, 13 Nov 2007, in microsoft.public.excel.charting,
Mortir <mare.rozman@gmail.com> 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 del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

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

--
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
>
>