littlejilly
Board Regular
- Joined
- Sep 8, 2011
- Messages
- 168
Hello all,
I am looking to alter the data source in a chart that I have in excel.
Currently, on my "Model Inputs" tab, I have a data validation in cells C49 and C51 where you can only have an X in one of those cells.
If cell C49 is checked, then the chart (titled - "ReimImpact") on the "Summary" tab will use the data also found on the Summary tab in cells (series1: N41, N49, N57, N65, N73, N81 ; series2: O41, O49, O57, O65, O73, O81). Alternatively, is cell C51 on Model Inputs is checked instead, then the data source will be cells (series1: N43, N51, N59, N67, N75, N83 ; series2: O43, O51, O59, O67, O75, O83).
Any suggestions on how to write the code and where it should go would be greatly appreciated.
Thanks,
jillian
I am looking to alter the data source in a chart that I have in excel.
Currently, on my "Model Inputs" tab, I have a data validation in cells C49 and C51 where you can only have an X in one of those cells.
If cell C49 is checked, then the chart (titled - "ReimImpact") on the "Summary" tab will use the data also found on the Summary tab in cells (series1: N41, N49, N57, N65, N73, N81 ; series2: O41, O49, O57, O65, O73, O81). Alternatively, is cell C51 on Model Inputs is checked instead, then the data source will be cells (series1: N43, N51, N59, N67, N75, N83 ; series2: O43, O51, O59, O67, O75, O83).
Any suggestions on how to write the code and where it should go would be greatly appreciated.
Thanks,
jillian