Thread: Excel Chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel Chart

Are there blank cells between cells containing data? By default, Excel
doesn't plot these cells, so it doesn't draw the lines connecting them. Go
to Tools menu Options Chart tab, and choose Interpolate for how you want
Excel to deal with empty cells.

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


"James E Smith" wrote in message
...
I am creating a line chart but the lines do not show. The tick marks are
the
only things showing. Also, I am trying to show my X-axis as 0 - 10 years
with
gridlines begining at 0 and ending at 10 for weach year. I really need
some
help.
--
JES