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

[Thej...@officeformac.com]

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

<Thej...@officeformac.com> wrote in message
news:59b5c...@webcrossing.caR9absDaxw...

[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.

In article <#qwsiDbK...@TK2MSFTNGP06.phx.gbl>,
"Mike Middleton" <mi...@mikemiddleton.com> wrote:

--
Team EM to the rescue! http://www.team-em.com