ExcelBanter - Hidden and Empty Cell Settings

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Hidden and Empty Cell Settings (https://www.excelbanter.com/charts-charting-excel/255852-hidden-empty-cell-settings.html)

Karl K.

Hidden and Empty Cell Settings

I have blank cells in an Excel graph. I would like to treat them as "Gaps"
instead of "Zero". However, this option (along with the "Connect data points
with line" option) is grayed out in the Hidden and Empty Cell Settings box.

All times are GMT +1. The time now is 04:38 AM.