View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default 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