Creating a chart referencing data in multiple sheets using a drop-down list of sheet names

**dops** · 07-20-2017, 12:25 AM

I need help in creating a date vs score chart in excel. The issue is that the chart should have a drop-down list containing the name of the sheets which have the data in it in such a way that when a sheet is selected from the list the chart displays the data regarding that particular sheet. I don't mind using macros to accomplish the task, so please guide me on how I can do it. Unfortunately I cannot attach the file since its 6MB size.

**AliGW** · 07-20-2017, 01:47 AM

Duplicate thread closed. Continue here, pleaae: https://www.excelforum.com/excel-pro...eet-names.html

Creating a chart referencing data in multiple sheets using a drop-down list of sheet names

LinkBack

Thread Tools

Display

Creating a chart referencing data in multiple sheets using a drop-down list of sheet names

Re: Creating a chart referencing data in multiple sheets using a drop-down list of sheet n

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] To-Do List: How to populate a sheet if drop-down criteria is met in multiple other sheets

Creating a Dependant Drop Down List from data in Multiple Worksheets in the same Workbook

Transferring data and creating multiple sheets with chart

List of names in one sheet corresponding to multiple sheets

creating a drop down list for names and addresses

creating a drop down list for names and addresses

Creating a chart using data from multiple sheets

Bookmarks

Bookmarks

Posting Permissions