LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Benihime
 
Posts: n/a
Default Dynamic chart: Changing Ranges

Hi:

I have a set of data, going across by months, and going down into different
categories that I have to graph using stacked column charts. Since the data
is going to be in the same columns, just going down a category...I'd like to
know if there is a way for me to add some kind of drop-down to the chart so
that users can just drop-down to CATEGORY 1, and see the chart for CATEGORY
1, without me having to build 10 different charts that i'll have to update
everytime i add new data.

I would appreciate any advice or feedback.
 
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
Prevent user changing pivot chart layout Jessica Excel Worksheet Functions 0 April 15th 06 12:24 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 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 08:58 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"