How to connect line chart dot in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I connect the data points in a line chart? I'm guessing they aren't
connecting because I don't have data for each point. So I want it to ignore
when there's no data and just connect the points that are there. I think
there was an option for this in pre-2007 versions, but I can't find it in
2007.

Thanks.
 
OMG, this was SOOOOO hard to find. I just spent half an hour on it! So it's
definitely not intuitive. And Help doesn't have anything about
interpolation, which is what this is really called.

Anyway, select the chart. On the Chart Tools Design tab, click the Select
Data button. In that "select data source" dialog box, click Hidden and Empty
Cells. In *that* "hidden and empty cells" dialog box, choose "connect data
points with line." Okay your way out.
 
Back
Top