View Single Post
 
Old 12-19-2022, 12:07 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Reply With Quote