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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Legend With No Data in Series
Hi. I have the exact same question. Did you ever figure out how to accomplish this?
Thanks. On Monday, February 22, 2010 3:13 PM GENESIS wrote: 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 am not well versed in it. Any thoughts or if VBA is the only way, can somone post the code? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Legend With No Data in Series
Jay Walker explained :
Hi. I have the exact same question. Did you ever figure out how to accomplish this? Thanks. On Monday, February 22, 2010 3:13 PM GENESIS wrote: 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 am not well versed in it. Any thoughts or if VBA is the only way, can somone post the code? Thanks. Have you tried using Autofilter with '(non blanks)' as the criteria? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
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 |