This content has been marked as final. Show 2 replies
I have some script that displays a chart when a selection is made in a different chart. Here's the columns in the first chart (a sales table):
UserID | Order ID | ProductID
So if a users clicks a UserID from the above chart, then another chart pops up showing some information about that UserID. Like this:
FirstName | LastName | Address | so on...
My issue is that I want a different chart to pop up if the user selects ProductID to show some information about that product.
So if i grab the chart:
How can I tell that the user selected a UserID vs a ProductID. Or maybe this info is saved in a sheet object?