How do I make a line graph WITHOUT first line starting at zero?

[Jon Peltier]

Do you want an XY chart instead?

- Jon

 

[NorthStar]

I want a line chart that doesn't have the line starting at zero. This is an
XY chart.

 

[Jon Peltier]

Define "Starting at zero". Is the first X value at zero? The first Y value?
In fact, what does your data look like?

Did you know an XY chart and a line chart can both be formatted with lines
connecting the data points? The XY chart provides more flexibility regarding
the X axis.

- Jon

 

[NorthStar]

Can you tell me how to connect the data points! That's what I want.

 

[David Biddulph]

For the chart as a whole, look at the sub-types against XY chart under Chart
Type. For an individual data series, Format Data Series.

 

[Jon Peltier]

Or double click on the series, and on the Patterns tab, format the line.

If for whatever reason you still are not getting a line, it's because of
blank cells between values, where the blanks are not being plotted. Go to
Tools menu > Options > Chart, and choose Interpolate in the top section.

- Jon

 

[NorthStar]

Is the only way of not having the lines start on zero, is by clicking on that
line and choosing "no Line". Or is there another way in someother option?

 

[David Biddulph]

In an earlier message on this thread, Jon Peltier asked you what you meant
by lines starting on zero. X = 0 ? Y = 0 ? He asked what your data looked
like.
As far as I can see, you didn't bother replying.

 

[Jon Peltier]

Thanks, David. That was going to be my next post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

In an earlier message on this thread, Jon Peltier asked you what you meant
by lines starting on zero. X = 0 ? Y = 0 ? He asked what your data
looked like.
As far as I can see, you didn't bother replying.
--
David Biddulph

Is the only way of not having the lines start on zero, is by clicking on
that
line and choosing "no Line". Or is there another way in someother
option?

Or double click on the series, and on the Patterns tab, format the line.

If for whatever reason you still are not getting a line, it's because of
blank cells between values, where the blanks are not being plotted. Go
to
Tools menu > Options > Chart, and choose Interpolate in the top section.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
For the chart as a whole, look at the sub-types against XY chart under
Chart Type. For an individual data series, Format Data Series.
--
David Biddulph

Can you tell me how to connect the data points! That's what I want.

:

Define "Starting at zero". Is the first X value at zero? The first Y
value?
In fact, what does your data look like?

Did you know an XY chart and a line chart can both be formatted with
lines
connecting the data points? The XY chart provides more flexibility
regarding
the X axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I want a line chart that doesn't have the line starting at zero.
This
is
an
XY chart.

:

Do you want an XY chart instead?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


message