Unable to show gaps for empty cells when plotting chart

Question

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?&nbsp;
&nbsp;

haytham amairah · Answer

This depends on the type of chart you have.
In stacked line chart or a 100% stacked line chart you only have zero option.

rsmccle · Answer

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!

larry oneil · Answer

Thank you!

mufi101 · Answer

Thank you! The only answer i found that worked!

Forum Discussion

Unable to show gaps for empty cells when plotting chart

4 Replies

Resources