Posted to microsoft.public.excel.charting
|
|
Excel Line or Scatter Chart
This worked. Thanks Jon!!!!
Millie
"Jon Peltier" wrote:
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/
_______
"Millie" wrote in message
...
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!!
|