exceljockey
Member
Hi
I am currently using Chandoos method of interactive graphs of having tables that populate to #NA for undesired values on the chart. So if i click january as the month, then all other months and values would go to #NA in the tables, so that the graph only shows Januarys values.
Now the problem is, if I want to show data labels then my graph will contain a bunch of #NA values, which is unpleasent to the eye. How do I make it so that any #NA values do not show on my data labels?
I hope I have explained the problem well enough, I can elaborate further if necessary.
Thanks
I am currently using Chandoos method of interactive graphs of having tables that populate to #NA for undesired values on the chart. So if i click january as the month, then all other months and values would go to #NA in the tables, so that the graph only shows Januarys values.
Now the problem is, if I want to show data labels then my graph will contain a bunch of #NA values, which is unpleasent to the eye. How do I make it so that any #NA values do not show on my data labels?
I hope I have explained the problem well enough, I can elaborate further if necessary.
Thanks