| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Legend With No Data in Series
Folks,
I have 8 series that get its value dynamically from other tabs. Sometimes, all 8 series would have data while other time, only a few. Question is, how do I hide the legend for those series that returned back blank value. I understand this may require VBA but I'm not well versed in it. Any thoughts or if VBA is the only way, can somone post the code? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the series order in a LEGEND ONLY...not data | Charts and Charting in Excel | |||
| hide legend for #N/A series | Charts and Charting in Excel | |||
| Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
| Hiding data series in legend | Charts and Charting in Excel | |||
| How to hide a dummy series in a chart legend? | New Users to Excel | |||
Threaded Mode
