Hi All,

Not sure if this is going to be possible...

I have a dashboard that i have set up using pivot tables and slicers, this is showing a graph of top 10 customers based upon sales value in the month. Is it possible to have a seperate graph, that will overwrite the first one if the user selects a individual customer to see what products they purchased in that month?

I dont have the space to display the two graphs side by side on the sheet, and also the data is a bit irrelevant unless looking at it by customer basis.

Let me know any ideas, if people need to see the sheet then let me know.

Cheers

Chris