| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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%? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing field names without affecting pivot table | Excel Discussion (Misc queries) | |||
| changing the width of a cell without affecting cells above or belo | Excel Discussion (Misc queries) | |||
| Changing Y Axis Scale with percentages (Line Graph) | Charts and Charting in Excel | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| Changing column widths w/o affecting all rows | New Users to Excel | |||
Linear Mode
