cisamcgu
Legendary Member
- Location
- Merseyside-ish
Calling Excel experts.
I want to create a simple line graph from the following data:
Seconds Value
0 0
100 34
120 45
200 67
207 78
300 90
350 89
390 104
400 109
Which I can do easily, however, Excel plots it as if the gaps on the x-axis are equal, whereas they vary between about 7sec and 100sec. Is there anyway to get Excel to adjust the x-axis so the points are plotted in the correct places ?
Notice that the gap between 0 -100 is the same size as the gap between 100-120, whereas the first gap should be about 5 times bigger than the second.
Any ideas ?
Thanks
Andrew
I want to create a simple line graph from the following data:
Seconds Value
0 0
100 34
120 45
200 67
207 78
300 90
350 89
390 104
400 109
Which I can do easily, however, Excel plots it as if the gaps on the x-axis are equal, whereas they vary between about 7sec and 100sec. Is there anyway to get Excel to adjust the x-axis so the points are plotted in the correct places ?
Notice that the gap between 0 -100 is the same size as the gap between 100-120, whereas the first gap should be about 5 times bigger than the second.
Any ideas ?
Thanks
Andrew