Report question

Question: Creating a chart in Excel that ignores #N/A or blank cells