Broken Lines on my Scatter Graph
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
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.
I knew there would be an option for it, I just couldn't find it,
Thanks for the help again Andy,
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks