Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
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 01: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 02:55 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Excel"