mindChaos
asked on
Getting the Current Selected Record on an Access PivotChart
Hello,
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.
I've used:
obj.SeriesCollection.Pivot Axis.Data. CurrentCel l.Aggregat es(0).Valu e, which returns always the same value regardless of the selected data series. (there's only one aggregate on the value axis)
and also:
obj.SeriesCollection.Pivot Axis.Data. CurrentCel l.ColumnMe mber.Capti on 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!!
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.
I've used:
obj.SeriesCollection.Pivot
and also:
obj.SeriesCollection.Pivot
I appreciate any suggestion on the matter (plus there are points too ;P)
Thank you very much!!
Forgot I had this link with sample code:
https://www.experts-exchange.com/questions/23266633/How-do-I-filter-an-OWC-Chartspace-chart-based-on-a-field-value.html?cid=238&anchorAnswerId=22805686#a22805686
https://www.experts-exchange.com/questions/23266633/How-do-I-filter-an-OWC-Chartspace-chart-based-on-a-field-value.html?cid=238&anchorAnswerId=22805686#a22805686
ASKER
Thanks for the quick reply puppydogbuddy! Very interesting things on the links you provided; but I'm filtering my pivotchart on a subform and works very smooth. I just need to be able to click on a data series and, at least, get an x co-ordinate indicating where the series is so I can go y-wise and get the values I need (+ the x values as well)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HTH