VBA to turn off Legends of plots that does not have data points

[vnzerem]

I will like to have a VBA code that can read through a chat to highlight the active legend alone. In my spreadsheet I have several plots, but I want only the plots with data points to display on the legend. I have attached an example in this spreadsheet.

In the attached spreadsheet you can see that the legend for plot3 is still showing even though there are no data points in it. The plots were created manually with the assumption that there will be data points in them.

So can someone help me out with a VBA code that will read through the chats and hide the legends that does not have data points (in this case it is plot3)? Also can the code be flexible to be able to bring back the legend when plot3 has values?
Thanks.

[vnzerem]

I basically want to know how to hide legend with no data in series.

[JoeFoot]

You can do it in a way to hide the name, but the legend icon (i.e. the green marker + line) will still show up. The only to eliminate the icon is to eliminate the series, but that means you will have to add it again once there is valid data.

The following code will remove the name but not the icon. It will also restore the name if data is available. You can alternatively code a way to add all the series to the graph, on condition that they have valid data but that is somewhat cumbersome to do in a quick forum reply.

Please Login or Register  to view this content.

[vnzerem]

@JoeFoot...Thanks a lot for the code. I will build more on it.