Hi All.

I was hoping for some advice on my current predicament. I basically have 20 graphs, they are name A, B, C, etc

Ideally I want only one graph to show dependent on a value in a particular cell. I had a look into naming ranges and using the offset formula but the quality sacrifice to the picture is too much, especially as the page being made will be published to PDF and printed.

Is there a way to have a macro in essence grab the chart I am looking for?

Or is it possible to overlay all charts on eachother and only have one become visible based on a cell input?

I am sure there are simpler ways to acheive my goal so any advice is much appreciated!

Thanks alot

Kind Regards

Mubzie