Jeffrey Lebowski
Member
Hello,
I am in the process of creating a nifty workbook (link below)--with loads of help from a handful of you ninjas--that takes raw data and uses a pivot table to organize the data to be used in several graphs. (I have not incorporated graphs yet).
The user clicks the metrics button and is then prompted on which quarters from the block of data they want to see graphed. Whichever quarter(s) they select is/are copied into a new sheet(Period).
I am struggling with the next step: the idea is to create two graphs (based on the two tables) that only display the range of quarters that they want. I would really appreciate any help with conceptualizing this and/or comments on what I have so far.
Thanks for helping!
https://www.dropbox.com/s/01d97a3azvry8gz/Book1.xlsm
I am in the process of creating a nifty workbook (link below)--with loads of help from a handful of you ninjas--that takes raw data and uses a pivot table to organize the data to be used in several graphs. (I have not incorporated graphs yet).
The user clicks the metrics button and is then prompted on which quarters from the block of data they want to see graphed. Whichever quarter(s) they select is/are copied into a new sheet(Period).
I am struggling with the next step: the idea is to create two graphs (based on the two tables) that only display the range of quarters that they want. I would really appreciate any help with conceptualizing this and/or comments on what I have so far.
Thanks for helping!
https://www.dropbox.com/s/01d97a3azvry8gz/Book1.xlsm