View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Millie
 
Posts: n/a
Default 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!!