Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scaling time on the x-axis of a graph
Can anyone help me with a problem I am having?
I have a spreadsheet showing 2000 data points plotted against time, sounds simple However, the number of data points corresponding to 1 second of 'footage' varies. E.g. in a 1 second interval, I sometimes get 5 readings being recorded (0.2, 0.4, 0.6, 0.8, 1.0 sec), and in the next 1 second interval, I get 10 readings being recorded (0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1.0 sec). When it comes to graphing the data, the time scale along the X-axis is not 'to scale', I am looking to have the tick mark labels to be displayed in 1 second increments (instead of say every 5 data points). Can anyone help me? Thank you so much in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scaling time on the x-axis of a graph
Use an XY chart, not a Line chart.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Callum" wrote in message ... Can anyone help me with a problem I am having? I have a spreadsheet showing 2000 data points plotted against time, sounds simple However, the number of data points corresponding to 1 second of 'footage' varies. E.g. in a 1 second interval, I sometimes get 5 readings being recorded (0.2, 0.4, 0.6, 0.8, 1.0 sec), and in the next 1 second interval, I get 10 readings being recorded (0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1.0 sec). When it comes to graphing the data, the time scale along the X-axis is not 'to scale', I am looking to have the tick mark labels to be displayed in 1 second increments (instead of say every 5 data points). Can anyone help me? Thank you so much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time on the X Axis Issue | Charts and Charting in Excel | |||
x/y axis graph | Charts and Charting in Excel | |||
How do you do a graph with a second Y axis? | Excel Discussion (Misc queries) | |||
xy scatter graph with a scrolling time element | Charts and Charting in Excel | |||
Y Axis - Horizontal Bar Graph | Charts and Charting in Excel |