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?
https://support.microsoft.com/en-us/office/display-empty-cells-null-n-a-values-and-hidden-worksheet-data-in-a-chart-a1ee6f0c-192f-4248-abeb-9ca49cb92274?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=90807&ui=en-us&rs=en-us&ad=us
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.
2 Replies
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.
