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("Chart 19").Visible = False
Sheets("Supporting Detail").ChartObjects("Cha