How to start an X-axis with zero on a line chart

[Thejew289]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi,

I'm trying to make a graph for a school science project.
We heated bottles for twenty minutes and recorded the temperature inside them.

However, i recorded the temperature before starting to heat the bottle and that was under 0 minutes.

The problem with the chart is that the x axis starts on 1 so the last measurement is after 21 minutes rather than 20.

So, my question is how do i change it so that the x-axis starts with the number zero and ends with 20.

please help, this assignment is due soon. i would really appreciate it.

 

[Mike Middleton]

Thejew289 -

One approach is to use an XY (Scatter) chart type instead of a Line chart
type. You will have much more control over formatting the axes. And you can
format the data series to have connecting lines if that's what you want.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Carl Witthoft]

Not to mention that a scatterplot will actually plot the VALUES of the
x-data.
A line plot simply treats the x-data as strings, and uses them to label
the graph.

So the lesson is: never ever ever use line graphs to plot data.