PivotTables and graphs

[wayneg]

Hi all, i have posted this in the general page, but got no help. i didnt want to duplicate it here, but moderator hasnt moved it accross. if they can, please mod, delete this one.


I have a 8 pivottables with a graph for each. is there a way that i can have a dropdown menu to select which graph to display instead of having all these graphs everywhere.... thank you

wayne

[Andy Pope]

rather than code consider using the linked picture approach

http://www.jkp-ads.com/Articles/ShowPicture00.asp

[wayneg]

i dont know if that will work as the graph will change each day when i refresh data from a data source

[Andy Pope]

Yes but the linked pictures would also update when the range they are linked to changes. I am not suggesting static pictures.

[wayneg]

ok, i will look into this approach.. thank you..