Hi all,
I would like to produce a pivot chart based on a cell selection. Depending on which product is chosen I would like the main chart to display the data from that product's particular worksheet. How do I go about this? Simple v-lookup's don't seem to apply... somehow loading a query or marco?
Example data attached.
Thanks in advance for any help given.
Matt
Bookmarks