Unable to show gaps for empty cells when plotting chart

Copper Contributor

I am trying to plot a chart that may sometimes contain blank values for the chart area. When I go to change the setting to "show gaps for empty cells", the option is grayed out. Why? 

 

Capture.PNG

4 Replies

This depends on the type of chart you have.

In stacked line chart or a 100% stacked line chart you only have zero option.

Thank you! The only answer i found that worked!

But why??? That's annoying, it forces the line to travel to zero and messes up my stacked line chart! I can't imagine the code to do that is too complex!