#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Dynamic Chart

I am working on worksheet that contains following tabs and each tab
contains following columns.

Company "A"
Months ( January 2006 to December 2008)
Forecast Data for Company "A"
Budget Data for company "A"


Company "B"
Months ( January 2006 to December 2008)
Forecast Data for Company "B"
Budget Data for company "B"

Company "C"
Months ( January 2006 to December 2008)
Forecast Data for Company "C"
Budget Data for company "C"

I plotted dynamic 2 line graph for each company successfully, I have
used for each company a drop down list ( from - view- toolbars-
forms) for months and a cell where I entered the number of month to
display ( example 5 or 6 ) on graph,

In short each tabs has one dropdown list for each company and entry
field for # of months, but my client requested me, instead of THREE
tabs and Three drop down list , he asked me to plot one graph.

First choose the company A or B or C and then choose months then
entered the numbers of months to display on the graph.

I really appreciate if someone advise me how I can accomplished or at
least give me some directions

Thanks

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
Dynamic Stacked Column Chart Help ksp Charts and Charting in Excel 2 June 20th 06 01:15 AM
Dynamic series for chart Jose Lopes Charts and Charting in Excel 0 March 27th 06 07:58 PM
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
Dynamic bar chart, must ignore "n/a" data... paris3 Charts and Charting in Excel 4 June 26th 05 07:07 PM
dynamic end on chart Donna YaWanna Charts and Charting in Excel 1 June 17th 05 04:50 PM


All times are GMT +1. The time now is 10:05 AM.

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"