View Single Post
  #1   Report Post  
Valeria
 
Posts: n/a
Default PivotChart: how to make it dynamic?

Dear experts,
I have a PivotChart with different entries, I have Gender on the x axis ,
sum of revenue on the y axis. In my original data I have the ages of these
people, and I would like to make it possible for the users of the chart to
input in an inputbox, or choose from a dropdownlist, or .... to select to see
the data only from a certain age on and/or for a specific age, for ex. 30
years old, or above 30 years old.

What I am doing today is that I am assigning age ranges (0-20,20-40,40-60,
etc), displayed as a field of the chart, but I thought that maybe there is a
more dynamic way to do this...

Thanks in advance.

Best regards,
--
Valeria