I have to populate a chart which is based on a particular field data(or a column value in a pivot table) .Initially the Chart wont be Visible.But when
that particular column is Clicked is selected the chart becomes visible and gets populated with data based on the field value Clicked.
This has been acheived.
But the fact of the matter is now suppose the field is present in a pivot table(along with a few other fields) and I have to populate the chart no matter
whatever field is clicked which means I have to select the field value based on the row of the table clicked.(This assuming whatever
Column is being Clicked it Corresponds to a Row in a table).
It can be something like this:
Get the Row number of the table or a pivot chart irrespective of which column value has been clicked.Now,Check the value of the
particular field corresponding to the Row and populate the Chart
