Not letting me use gaps button

Copper Contributor


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


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.