Hi Everyone,

I have 13 charts called Chart1, Chart2, Chart3, etc..

Essentially, I want each of these charts to appear only if there is a text value in an assigned cell (i.e. if the assigned cell is not empty)

Thus Chart1 should only appear if cell A1 has text (or alternatively, if cell A1 has the text value, "Chart1")

Chart 2 should only appear if cell A2 has text.

Chart 3 should only appear if cell A3 has text. etc...

I'd prefer to use VBA than some of the other tricks I've seen out there, but I couldn't begin to write this in VBA myself.

Can anyone help me out? Thanks!

Jay