Excel charts - excluding columns with NA values

[manekankit]

I have a table where sales data gets updated based on user selection. A chart is prepared from this table. (image attached).

1. If user selects monthly on pivot slicer, sales data for month will appear and sales data for quarter will show #NA error.
2. If user selects quarterly on pivot slicer, sales data for quarter will appear and sales data for individual months will show #NA error.

So, there is only one table and one chart. Data in table get updated based on user selection and chart will accordingly get updated.



Query

Is is possible to exclude column titles on chart where where column has #NA errors?



Using office 365 on desktop. OS win10Pro.

 

[manekankit]

I just found a workaround. Used filter function to exclude error values from the table and then linked chart to new table prepared through filter function.