I started a small Access 2003 project that handles stoked items. I started playing with a pivot chart (for the first time may I say) and got a pretty good idea of how it works. I want the user to click on a data series on the chart and fill some textboxes with the corresponding data. I can loop through the category axis and get the values there may be but that's not what I need.
I need to catch on the SelectionChange event the current selected data series to then "find a way to" take it as reference to get the other values I need to fill in the boxes.
obj.SeriesCollection.PivotAxis.Data.CurrentCell.Aggregates(0).Value, which returns always the same value regardless of the selected data series. (there's only one aggregate on the value axis)
obj.SeriesCollection.PivotAxis.Data.CurrentCell.ColumnMember.Caption that returns always the same value as well.
I appreciate any suggestion on the matter (plus there are points too ;P)
Thank you very much!!