goldfrapp01
New Member
- Joined
- Jan 24, 2013
- Messages
- 27
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. So now I have two lines: 1st line (2010, 2011, 2012)+(GAP)+ 2nd line (2013, target).
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?
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. So now I have two lines: 1st line (2010, 2011, 2012)+(GAP)+ 2nd line (2013, target).
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?
