VBA to show one chart or another based on criteria

[SAsplin]

Hi guys,

Not even sure where to begin with this one....

I have a two charts in a spreadsheet called "Data", imaginatively called "Chart1" and Chart2".

What I'd like:

On another spreadsheet (same workbook) called "Chart" I'd like to display one or other (not both) of the charts, based on the following criteria:

Cell A2 in Data = 1 show Chart1
Cell A2 in Data = 2 show Chart2
Cell A2 in Data = "" then display nothing.

Is this making any sense?

Cheers for any help you can give on this!

SA

[SAsplin]

Would the easiest way be linking the charts to an image control?

[SAsplin]

No worries. I've sussed it myself.