I have created a pivot table with vendor names in Column A (rows) Data fields are broken down by office, current year and goals (columns). Is it possible in excel 97 to create drop down menu that you could select the office from there would access the pivot table, go to that office information and create a chart. Would I need to do a Select Case?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Charting Office 97
- Thread starter Adams
- Start date
