Hi,
Can someone please help me out with having a bar cart ignore NA#? I basically just need a bar chart that counts unique values and ignores the x-axis labels when #NA or NO DATA is present in the list. The list is dynamic, so if the user does not enter data, it will return NA# or 0. I can't get the bar chart's x-axis to ignore any of these no matter how I do it.
The chart simply needs to dynamically display the count on y-axis and the value on the x-axis.
I have attached a sample. I prefer no VBA. But can use his necessary.
Thank you for your time.
FILE:
Bookmarks