View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default "line chart" won't display lines

If they are 4 different series on your graph, then you won't be able to draw
a line between the series. If you want the points joined by a line, you'll
need to put them in one series. "Source Data" option, either from the Chart
menu or from right-clicking on the chart. Also, if the line chart isn't
letting you do what you want in terms of the X-series, you may prefer XY
chart (confusingly named scatter).
--
David Biddulph

wrote in message
oups.com...
Hi there,

I have four time series sets of data points. want to convert them into
a line chart. excel displays the data points, but does not connect them
with lines. i have clicked on the data series, selected automatic -- it
did not work. i tried custom, and selected a line, then a thicker line,
and these did not work. I'm sure its simple, but I couldn't find a
solution on the internet. can anyone help? thanks!