Using Drop Down to Switch Betw Charts

[azscootergirl]

Hello! I'm using Excel 2010... I have a pivot table with my data that shows 3 different types of values (total sales, # of sales, and # of sales people in that location). I have 5 locations in my row column.

Someone at work told me there was a way to use a drop down list that contains each of my values and when selected, that chart would come up on my sheet. This sounds like a great way to save worksheet space and still show all my data. He didn't know how to set that up - so I'm wondering if anyone here can assist?

Thank you!

[dflak]

We can help you better with something concrete to work with.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.