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

Hello
I don't think you can put attachments in private messages, so I've attached my original file here (Example4_Reply), it still seems to work. I've also attached an amended version of my last reply (Example7). I've added a combo box to each chart, working from a lookup table, where you can select any other chart. It requires only 1 click and you get a full page view of each chart. I don't think it can be simpler. As I don't know the folks you're designing the spreadsheet for, I don't know what else to suggest at the moment.

Hope this helps.
DBY