Excel Line or Scatter Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Millie - 10 Feb 2006 23:02 GMT

I have created a line chart with markers. The markers show, but the lines do
not. So I tried doing the chart as a Scatter chart with markers and lines,
and the lines still don't show.

What am I doing wrong?

Help!!

Reply to this Message

Michael R Middleton - 10 Feb 2006 23:35 GMT

Millie -

Either a Line chart type or an XY (Scatter) chart type can be formatted to
show any combbination of lines and markers.

Click a data point to select the data series. Choose Format Selected Data
Series, and click the Patterns tab. Choose the settings you desire.

- Mike
www.mikemiddleton.com

>I have created a line chart with markers. The markers show, but the lines
>do
[quoted text clipped - 4 lines]
>
> Help!!

Reply to this Message

Jon Peltier - 12 Feb 2006 01:57 GMT

Are there blank cells in the data range? By default, Excel doesn't plot
them, leaving a gap in their place. To force Excel to draw a connecting line
across this gap, select the chart, go to Options on the Tools menu, and on
the Chart tab, where it says Treat Blank Cells As..., select Interpolate.

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

>I have created a line chart with markers. The markers show, but the lines
>do
[quoted text clipped - 4 lines]
>
> Help!!

Reply to this Message

Millie - 14 Feb 2006 17:16 GMT

This worked. Thanks Jon!!!!

Millie

> Are there blank cells in the data range? By default, Excel doesn't plot
> them, leaving a gap in their place. To force Excel to draw a connecting line
[quoted text clipped - 17 lines]
> >
> > Help!!

Reply to this Message

Jon Peltier - 12 Feb 2006 02:00 GMT

Pardon me if this appears twice, but Outlook Distress seems to have eaten
the first one.

Are there gaps in the source data? By default Excel ignores these blanks,
leaving a gap in the chart. You can tell Excel to draw a line across the
gap. Select the chart, go to Options on the Tools menu, and on the Chart
tab, where it asks how you want to deal with blank cells, choose
Interpolate.

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

>I have created a line chart with markers. The markers show, but the lines
>do
[quoted text clipped - 4 lines]
>
> Help!!

Reply to this Message

Millie - 14 Feb 2006 17:16 GMT

This worked. Thanks!!!!

> Pardon me if this appears twice, but Outlook Distress seems to have eaten
> the first one.
[quoted text clipped - 21 lines]
> >
> > Help!!

Reply to this Message