Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make graphs in Excel all the same size ready to paste into Word - | Charts and Charting in Excel | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
I would like to make a schedule for my dept. Who works what days . | Charts and Charting in Excel | |||
I would like to make a schedule for my dept. Who works what days . | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |