![]() |
#2
|
|||
|
|||
![]()
Instead of single column, have 2 columns in source table. In one of them, use NA() to return an error code, when there must be gap in graph, and values otherwise. In another column, use NA() for those rows where you had values in 1st one, and some appropriate value otherwise. Have both columns display a line (coloured differently) in your graph. I don't remember exactly how, but you can have a gap in line graph for N/A's in table.
|
Tags |
break tracking, plotting breaks, team attendance |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
agorgainc | Excel | 2 | 12-23-2015 04:06 PM |
![]() |
Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
Difficult Graph To Plot..Please help | Jago147 | Excel | 0 | 02-18-2014 02:30 PM |
Naming plot-line breaks dates on x-axis | Sammael | Excel | 0 | 06-01-2013 03:29 PM |