getting chart legend to ignore #NA s!
I would use IF IS ERROR in each cell or ISNA to get a blank cell instead of a
#N/A
"arran1180" wrote:
Hi there,
I have a pei chart based on a dynamic table that sometimes contains #NA for
the rows data.
The chart updates fine, but in the legend i get an entry for every row -
including all the NAs! is there any way i can avoud this that you can think
of?
I've used VBA plenty in Access, so am prepared to have a bash writing any
code in excel with any pointers you may have!
thx
|