Hi there,

There's a somewhat simpler way to achieve this if you don't need the charts to be displayed simultaneously.

Create a single chart which takes its data from a specific "Chart Data" range, and use appropriate Lookup functions to populate that range with whichever data you wish to display.

One slight advantage of this approach is that you have only a single chart to maintain if you subsequently wish to play around with layouts/fonts/sizes etc.

Regards,

Greg M