View Single Post
  #2  
Old September 11th, 2009, 03:23 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Changing Numebers on Y Axis, without affecting Graph

Well, first of all, 4 out of 5 is 80%. Second, charts plot whatever is
input. If you want to plot percentages, you have to calculate them, and
plot the calculations.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



BRamos wrote:
I have a simple bar I created showing sites that have construction done. Is
there anyway to have excel convert my data into a % (out of 100%) and graph
my items? I do not want to do the math for each individual peice of data.
Example: I have on peice of data that basically says 4 out of 5 were
completed. How can I make excell chart that as 90%?