Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Stacked Column Chart Help | Charts and Charting in Excel | |||
Dynamic series for chart | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic bar chart, must ignore "n/a" data... | Charts and Charting in Excel | |||
dynamic end on chart | Charts and Charting in Excel |