asked on Hide chart legend using VB
I am trying to find a way to hide / unhide a chart legend using VB (it will be based on user selections)
I have found code to hide a full chart, which works great…but I only want to hide / unhide the chart legend.
I don’t want to just delete the chart legend, b/c I want to preserve the established format, position, etc so when it’s unhidden, it will be formatted as needed, and in the proper position.
Code below to hide full chart….I only want to hide the chart legend.
Sheets("Supporting Detail").ChartObjects("Cha
I have found code to hide a full chart, which works great…but I only want to hide / unhide the chart legend.
I don’t want to just delete the chart legend, b/c I want to preserve the established format, position, etc so when it’s unhidden, it will be formatted as needed, and in the proper position.
Code below to hide full chart….I only want to hide the chart legend.
Sheets("Supporting Detail").ChartObjects("Cha
Microsoft ApplicationsProgramming Languages-Other
Last Comment
byundt
ASKER
byundt - Thanks for the responce.
However, as mentioned in my original post, I do not want to delete the legend as I want to presevre the format, position, etc, etc or the legend when it is unhiden.
I only want to HIDE the chart legend.
However, as mentioned in my original post, I do not want to delete the legend as I want to presevre the format, position, etc, etc or the legend when it is unhiden.
I only want to HIDE the chart legend.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The solution provided was informative, but did not fullly meet the needs of what I was trying to accomplish. I ended up going a nother route.
CyHill,
What exactly did you end up doing?
Describing the method you ended up with would be much more valuable in the Experts Exchange database than merely stating "I ended up going another route."
Brad
What exactly did you end up doing?
Describing the method you ended up with would be much more valuable in the Experts Exchange database than merely stating "I ended up going another route."
Brad
Sheets("Supporting Detail").ChartObjects("Cha