Hi
I have a chart example that allows the user to click an item in the drop down list and a different chart displays.
They have example code using offset to select each item of data. Does anyone know how to get the list to select the correct data to chart?
I am attaching an exampleof some of the code being used. I have looked at several "Google" results and no luck
Thanks
Elaine
A2 CONCATENATE("Results for ",INDEX(A6:A11,A4))
Data OFFSET(Chart!$A$4,Chart!$A$4,1,1,4)
Metric_Name OFFSET(Chart!$A$4,Chart!$A$4,0,1,1)
Time Conversion 60*(MID(B12,6,2))+MID(B12,9,2)
Bookmarks