close

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!!

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

quot;Milliequot; gt; wrote in message
...
gt;I have created a line chart with markers. The markers show, but the lines
gt;do
gt; not. So I tried doing the chart as a Scatter chart with markers and lines,
gt; and the lines still don't show.
gt;
gt; What am I doing wrong?
gt;
gt; Help!!
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
PeltierTech.com/
_______

quot;Milliequot; gt; wrote in message
...
gt;I have created a line chart with markers. The markers show, but the lines
gt;do
gt; not. So I tried doing the chart as a Scatter chart with markers and lines,
gt; and the lines still don't show.
gt;
gt; What am I doing wrong?
gt;
gt; Help!!
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
PeltierTech.com/
_______

quot;Milliequot; gt; wrote in message
...
gt;I have created a line chart with markers. The markers show, but the lines
gt;do
gt; not. So I tried doing the chart as a Scatter chart with markers and lines,
gt; and the lines still don't show.
gt;
gt; What am I doing wrong?
gt;
gt; Help!!
This worked. Thanks Jon!!!!

Millie

quot;Jon Peltierquot; wrote:

gt; Are there blank cells in the data range? By default, Excel doesn't plot
gt; them, leaving a gap in their place. To force Excel to draw a connecting line
gt; across this gap, select the chart, go to Options on the Tools menu, and on
gt; the Chart tab, where it says Treat Blank Cells As..., select Interpolate.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Milliequot; gt; wrote in message
gt; ...
gt; gt;I have created a line chart with markers. The markers show, but the lines
gt; gt;do
gt; gt; not. So I tried doing the chart as a Scatter chart with markers and lines,
gt; gt; and the lines still don't show.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; Help!!
gt;
gt;
gt;

This worked. Thanks!!!!

quot;Jon Peltierquot; wrote:

gt; Pardon me if this appears twice, but Outlook Distress seems to have eaten
gt; the first one.
gt;
gt; Are there gaps in the source data? By default Excel ignores these blanks,
gt; leaving a gap in the chart. You can tell Excel to draw a line across the
gt; gap. Select the chart, go to Options on the Tools menu, and on the Chart
gt; tab, where it asks how you want to deal with blank cells, choose
gt; Interpolate.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Milliequot; gt; wrote in message
gt; ...
gt; gt;I have created a line chart with markers. The markers show, but the lines
gt; gt;do
gt; gt; not. So I tried doing the chart as a Scatter chart with markers and lines,
gt; gt; and the lines still don't show.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; Help!!
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()