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

You could put Age and Age Group in the page area of the pivot chart, and
let users select a group, or specific ages, to view.

Valeria wrote:
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...

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html