Forum Discussion
Want breaks in line graph
I'm trying to follow this to see gaps in my line graph, but the gaps option is grayed out. What to do? Display empty cells, null (#N/A) values, and hidden worksheet data in a chart - Microsoft Su...
I was able to get this to work by manually adjusting the line to no line for the marker to the right of the line I didn't want to appear.
I don't understand how the chart relates to the data, but the Gaps option is not available for stacked charts.
