Thread: Dynamic Chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
krais krais is offline
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