Hello Excel friends, I'd really appreciate some assistance.
I am using Excel 2016 for Windows on my PC.
In my SampleChart spreadsheet, I have a graph on my CHART sheet. Next to the graph on that sheet in cell $I$3 I have a Drop Down that gives me two choices, JAN or FEB, the names of my other two sheets.
From my graph, I go to my Chart Filters > Select Data to the 'Select Data Source' window. In the "Chart Data Range" I need to enter the range to include my source sheet selection from $I$3 followed by the range $A$1:$D$4. I currently use 'FEB'!$A$1:$D$4 but have to manually change the sheet instead of using the drop down.
I need to use the drop down.
So how can I change the 'FEB' to an INDIRECT() or whatever works to complete this? Of course the combination of single and double quotes is the toughest part.
Thanks for any help offered.
Bookmarks