if statements in Select Data line

[puzzlelover22]

Hi All,

Is it possible to write if statements in the select data line when I'm making a chart? I have limited space to pack a number of times series charts so I was hoping that maybe I could include a drop down where the user could select the time series set that he/she wanted and have the chart populate with the appropriate data.

Is this possible?

Thanks for the help,

Alex

[ben_hensel]

Create a chart-building table, and run that out from the data table based on a dropdown.

I just used double-lookups, which might get expensive to ask the computer to do over and over again if you've got huge data sets; I'd probably go to building from OFFSET or something.