If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing Numebers on Y Axis, without affecting Graph
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%? |
#2
|
|||
|
|||
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%? |
Thread Tools | |
Display Modes | |
|
|