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;
- Nov 21 Wed 2007 20:40
Excel Line or Scatter Chart
close
全站熱搜
留言列表
發表留言