LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
I would like to make a schedule for my dept. Who works what days . Chiki Charts and Charting in Excel 1 December 9th 04 12:19 AM
I would like to make a schedule for my dept. Who works what days . Chiki Charts and Charting in Excel 0 December 6th 04 01:55 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"