Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |