| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 82777 | 2007-09-07 11:04:00 | True spread sheet x-y graph? | Zoober (12586) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 588874 | 2007-09-07 11:04:00 | Any one know of a plugin for excel or quattro pro (or even a stand alone program) that will do a true x-y graph? Excel and quattro pro only seem to be able to do charts (ie the y-values are independent of the y-axis scale but the x-values and x-axis scale are locked together.) What I would like to be able to do is to first set the x-axis scale and y-axis scale separately and then plot each data point according to its respective x and y value. You know just like we used to do at school on a piece of graph paper. Example: y-axis scale $0 to $100 in $10 steps x-axis scale 0 to 18 months in 2 month steps data points y - x $2 - 1mth $9 - 2mths $45 - 7.5mths $51 - 8mths $64 - 9.2mths $95 - 11mths Seems simple enough eh. Give it a try on your spread sheet and let me know if you have any success. cheers zoob |
Zoober (12586) | ||
| 588875 | 2007-09-07 11:40:00 | Not doing your homework for you:) | beeswax34 (63) | ||
| 588876 | 2007-09-07 20:43:00 | Hi Zoober You don't need any add-ons to do this in Excel: have your data in columns with the 'months' values in the left column, select both columns then Insert/Chart/XY(Scatter); select the "Scatter, compares pairs of values" option;Next; and it should be there for you to customise with gridlines, scales, trendlines etc. Let me know how you get on, cheers, rtch |
Ritchie (12794) | ||
| 588877 | 2007-09-08 10:25:00 | Hi Ritchie, Thanks a heap for your input. I forgot to mention that my version of Excel is pretty ancient. I could follow your instructions ok it just took me a couple of extra steps. Once I turned off the auto scaling feature I could manually scale the x axis and y axis independent of the x-y data values. So I think this must have been why I was having a problem before. Scatter works well as a line graph. Any suggestions on how to convert it to an area graph? This is not an option in my scatter menu. zoob |
Zoober (12586) | ||
| 1 | |||||