Not letting me use gaps button

Copper Contributor

image.jpg

How can I allow my excel to let me use the gaps feature? I want the whole month to show for my graph, but want the line to stop at the month I am working on. 

1 Reply

@Caroline_Zimmerman 

It depends on the chart type. The Gaps option is disabled for

  • Stacked Line Chart
  • 100% Stacked Line Chart
  • Stacked Area Chart
  • 100% Stacked Area Chart

and perhaps more.