| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting chart legend to ignore #NA s!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding a non-plotted chart series in legend | Excel Discussion (Misc queries) | |||
| Change default settings for surface chart legend | Charts and Charting in Excel | |||
| Chart Legend Items: hide/show | Charts and Charting in Excel | |||
| How to hide a dummy series in a chart legend? | New Users to Excel | |||
| Stack Chart Legend Display | Charts and Charting in Excel | |||
Threaded Mode
