Update chart data based on answer in another cell

**allwrighty** · 12-22-2016, 04:18 PM

Hi

I have attached a sample of the file I am working with. I need to be able to change the selected chart data based on a yes or no entry in cell $B$19.

If the answer is "No" then I want to select the data for the chart that matches the SLA criteria for a "Non-enrollment" period along with the chart title.
If the answer is "Yes" then I want to select the data for the chart that matches the SLA crieria for an "Enrollment" period along with the chart title.

Let me know if you need any further info.
Thanks in advance for your help.

**dflak** · 12-22-2016, 05:26 PM

And plot them where? If I say no, you want a new line on each chart at 75% and if yes, a new line on each chart at 98%?

**dflak** · 12-22-2016, 05:33 PM

I see your "hidden" columns in rows 1 & 2 and where which is used by which chart. Use this formula in these cells =IF($B$19="No",0.75,0.90).

**allwrighty** · 12-22-2016, 06:24 PM

Hi Dflak

Thanks, that worked for plotting the "goal" on the charts. Now I need to do the same for the selected data.
So if "no" is entered in cell $B$19 on the top chart (which would be % Calls Answered Within 20 Seconds) I want to display the data from cells B7:J7 in the line graph
If "yes" is entered in cell $B$19 on the top chart (which would be % Calls Answered Within 60 Seconds) I want to display the data from cells B9:J9 in the line graph