Connect/disconnect separate data points in line chart?

Hi everyone,

I have an issue with line charts in Excel 2013. I'd like to chart performance by year (2010, 2011, 2012) where the dots are connected with a line, and I'd like to have the target performance as a point which is disconnected from the rest.

I worked on an existing document and (2010, 2011, 2012) + (target) appeared fine, but when I added 2013, it connected to the target point, rather than to the previous years' points.

The data table has the data series in columns C,D,E,F for data and H for the target point. The select data series looks like:

=(Trends!$B$34:$F$34,Trends!$H$34)

where G has been left empty - hoping that this will create a gap between the points but it didn't. I tried "Select Data" > Hidden and empty cells > Show empty cells as gaps, this did not work either.

I am trying stuff for hours without success, does anybody know how to connect and disconnect points on the line?

line chart.png

Originally Posted by Andy Pope

post an example workbook rather than a picture

Sorry about that, here is an example, thank you very much for looking into this!

example.xlsx