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 Support
Note: This is fake data, just testing out the line graph formatting.
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.
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.
