Show / hide chart based on value in cell assigned to chart (multiple charts)

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

Thanks, Kaper! This looks great, but I don't know how to enter this VBA code.

Also, I forgot to mention that the chart (actually called, "Group 14") is on a worksheet called, "Charts". But cell A1 is on a worksheet called, "Data".

I'll attach an image of what I tried to do.

Can you advise me further on how to revise the code and where to enter it?

Thanks!!

Jay

Can anyone else share a tip here? Thanks!

Jay

Hi Kaper,

Thanks very very much for the code you suggested. I have 3 more questions, if you don't mind:

1) How do I have the code run only when the user clicks on the "Charts" tab to view the "Charts" worksheet? Can you take the first code snippet (without the loop) and show how that would be done?

2) The reference cell (A1) is actually on the "Data" worksheet. How should the code be changed?

3) The size of my object group (Group 14) isn't the same size (400 x 300) that you used as an example. However, I can't figure out how to determine the size of my object in pixels. In the Format Chart Area panel, it's defined as 6.44 inches (width) x 4.28 inches (height). How can I determine it's dimensions in pixels? Or, alternatively, can I use define the visible size as 100%?

Thanks so so much for your guidance!

JayUSA

Kaper,

Thanks for your help. I was curious if there might be a solution that doesn't involve specific dimensions, and I seem to have found one which I combined with your general structure:

Please Login or Register  to view this content.

Thank you for replies to my question. They really really helped!

JayUSA

Hmmm... there's no edit option for original post. So i don't know how to mark as solved. Any ideas?

JayUAA