Hi All,

I have a dynamic chart, allowing me to select which series I wish to show. My problem is that, for any series I don't want shown, the series colour is still showing on the legend. I know I can select the colour on the legend and simply delete but is there some way (VBA?) that I can get this to happen automatically (by basing the colour on a cell value maybe?)?


Thanks in advance.