Multiple graph selections using a dropdown list

Hello,

I have a small workbook of maybe 5 sheets and currently only two graphs. I am intending on this being a lot more before I am done. I have Excel 2010 and tried the picture link to switch between graphs but was unable to enter anything into the formula window.

is there a simple way of switching between graphs that are not on the same sheet? Thanks in advance.

John

You'll probably have a tough time linking to the chart instead of a cell with a picture link.

If you want, like, a popup dialogue box with different locations called out that you can jump to with a double-click, then use the watch window, that's simple and non-VBA (although that can only be used to link to cells, not to the charts, you can just point to cells that are "underneath" the chart or something).

ben_hensel, thanks appreciate the feedback.