Quick lay out... I have a chart with multiple columns, up to Z and over 4000 rows. The rows contain dates from 2003-future. I have another page that draws data from this page by users selecting information from drop down menus.
From the information they select in the drop down menu I want a chart to populate, ideally with the last 3 months of data for the selected column they are referring to.
I was thinking of using a concatenate formula or something to get this. So if I did "=CONCATENATE("A",B10,":A",B11)" B10 and B11 just refer to numbers. So what that formula gives me is A643:A700 and this would be the date range. Then I could also accomplish this sort of thing for the column and same range as to their selections.
The Problem: I can't use formulas like that in a basic chart creation!
Solution: ??? Anyone have any suggestions? I already know about the option of creating dynamic charts and naming all my ranges ahead of time etc... thats not an option for me.
Thank you!
From the information they select in the drop down menu I want a chart to populate, ideally with the last 3 months of data for the selected column they are referring to.
I was thinking of using a concatenate formula or something to get this. So if I did "=CONCATENATE("A",B10,":A",B11)" B10 and B11 just refer to numbers. So what that formula gives me is A643:A700 and this would be the date range. Then I could also accomplish this sort of thing for the column and same range as to their selections.
The Problem: I can't use formulas like that in a basic chart creation!
Solution: ??? Anyone have any suggestions? I already know about the option of creating dynamic charts and naming all my ranges ahead of time etc... thats not an option for me.
Thank you!
