https://grandslambids.com/32-charts-not-updating-in-excel/charts-not-updating-in-excel-excel-2007-ignore-blank-cells-chart-how-to-update-cells/