Programatically change Chart.Items and Chart.Series1

[codebrane]

I have a bar chart with Items set to:

AddColumns(Filter('TestList', StudentId = Student.StudentId),"Test Name",TestName.Value)

and Series1 set to "Test Name" and all is working.

I need to change Chart.Items and Chart.Series1 on the fly, based on a droplist selection, so a new bar chart displays with the new data. Is this possible? Trying from a button doesn't work as there is no way to access Chart.Items or Chart.Series1 from code. Looks like I can only affect the look and feel of the chart rather than the data it displays.

thanks,

Alistair

[codebrane · Accepted solution]

Turns out I can do it by creating a collection in OnVisible and using that as the Chart.Items. In the button or drop down, I can then manipulate the collection and the chart updates automatically.