Excel Graph – Ignore Blank Cells | Hide #N/A Values | Stop Line Graph Dropping to Zero

Microsoft Excel Tips and Tricks

In this video I explain how to ignore the following when creating a chart in Excel:

Credit Chester Tugwell