| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 54779 | 2005-02-22 03:06:00 | MS Excel Chart - scaling | Linbug (7400) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 327328 | 2005-02-22 03:06:00 | I use an older version of Excel ('97). Made a chart with temperature on y-axis and time on x-axis. For some reason the scale on x-axis is incorrect for the first two inputs. i.e. twice as wide as the rest of the scale. Anyone got any ideas why this should happen? I have tried deleting some of the input data i.e. an extra reading which created a 5-minute interval instead of a 10-minute one, but it made no difference. I need this scale to be accurate. Alternatively could anyone suggest alternative software for graphing purposes? thanks. |
Linbug (7400) | ||
| 327329 | 2005-02-22 03:20:00 | I use an older version of Excel ('97). Made a chart with temperature on y-axis and time on x-axis. For some reason the scale on x-axis is incorrect for the first two inputs. i.e. twice as wide as the rest of the scale. Anyone got any ideas why this should happen? I have tried deleting some of the input data i.e. an extra reading which created a 5-minute interval instead of a 10-minute one, but it made no difference. I need this scale to be accurate. Alternatively could anyone suggest alternative software for graphing purposes? thanks. |
Linbug (7400) | ||
| 327330 | 2005-02-22 04:41:00 | This was a duplicate posting of threads, so I have merged them in one. | Jen (38) | ||
| 327331 | 2005-02-23 01:49:00 | I'm not quite sure what you are describing . :confused: have you got something like: 0---------5--------10---15---20--- where you should have: 0----5---10---15---20---25---30--- ? That is either funny input data (autoscaling can go a bit "strange" if there are missing data points) or a funny programme . Or both . You mention deleting extra points . . . did you remove both the time and temperature data, or just the temperature? Can you specify the scaling . . . I always used to because the primitive autoscaling would always give ticks at "0 . 12382e02" and multiples . :groan: Gnuplot does everything and is free . . . I'd guess that it's been ported to Windows . It's not all that user friendly, but a simple X-Y plot isn't too bad, and there are examples and lots of help . |
Graham L (2) | ||
| 327332 | 2005-02-23 02:22:00 | To give equal spaced data on the graph, the data must be continuous in columns or rows ie no empty cells within the data range. Maybe this is the problem. | rad_s4 (7401) | ||
| 1 | |||||