Unable to show gaps for empty cells when plotting chart

[Larry ONeil]

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? 

[#2]

This depends on the type of chart you have.

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

[#3]

Thank you!

[#4]

Thank you! The only answer i found that worked!

[#5]

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!