Legend Only Shows Used Axis on Dynamic Chart (X, Y and Y2 axis)

Hi
The only way I know to do as you require is to use a some VBA code. Now I'm no expert with VBA, so I'm not sure how good the code is in my attachment but it seems to work. If any of our forum Gurus can improve the code, or know of a none VBA solution I'd be happy to learn. There are 2 sub routines in Module1 and a worksheet Calculate event which triggers the code based on the value in cell L30, which contains a formula. One routine hides column E which removes the Secondary series and it also removes the Axis values and Title. The other routine reverses the process.

Hope this is of some use.
DBY