Broken Lines on my Scatter Graph

[chrismann85]

Hi all,

Please see the dummy attached workbook. I have created a chart (chart 1) based on the table in sheet 1, howvever it gives me broken lines in the chart for some reason which it hasn't done before. Is this because there are blanks in the table? I have never had this before so any help would be very much appreciated.

Thanks,

Chris

[Andy Pope]

Yes the breaks are caused by the empty cells.

If you wish the lines to remain unbroken the select the chart and use Tools > Options > Chart > Plot Empty Cells As > Interpolated.

[chrismann85]

I knew there would be an option for it, I just couldn't find it,

Thanks for the help again Andy,

Chris