Forum Discussion
Unable to show gaps for empty cells when plotting chart
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?
This depends on the type of chart you have.
In stacked line chart or a 100% stacked line chart you only have zero option.
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!