Applying direct formatting to spilled arrays in Excel could cause issues if the data changes shape or size. Formula-based ...

Then click Apply. Follow the steps below on how to ignore blank cells in Excel: Select a blank cell next to the values that you want to use to create the chart and type the formula =IF(ISBLANK(C2 ...