2 Replies Latest reply: Nov 9, 2010 5:12 PM by moshea444 RSS

    Determine which column was clicked in OnSelect

      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?