I have a graph for a formatted table in Excel.
I have a classic issue with empty values that are reflected on graph as zero and the "Connect data points with line" option is disabled. I can't check it.
I googled but never found the answer. Does anybody know why?
UPDATE: SOLUTION: After I added more columns for the graph and removed the heading column from the graph, the options "Gaps" and "Connected data points with line" became enabled.
I got round something similar by duplicating the data series and replacing zero values with #NA, then my chart worked fine.
Not found that answer yet, but it is on here somewhere: