I have 10 data series in a sheet, and each data series corresponds to a cell that is written in a separate sheet. eg. 1m1m in Sheet 1 corresponds to 1yr timeline data for 1m1m written in Sheet 2; 1m1y in Sheet 1 corresponds to 1yr timeline data for 1m1y written in Sheet 2.
Is it possible to write a code so that if a user clicks on 1m1m cell in sheet 1(not tab); then the XY scatter plot I have in Sheet 1 takes the values from the Table that corresponds to 1m1m and so on and so forth.
Many thanks,
Hi,
this is possibly doable without macros, just some dynamic range names and a data validation list the user chooses from.
But it will be easier to solve if you could upload a sample file. Include the data for three graphs and we can take it from there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks