PDA

View Full Version : VBA Charting Date Ranges



kantian1
11-23-2008, 09:34 AM
Hi All,

I have another problem. Take a look at the file attached; I am trying to design a charting tool that can graph up to five sets of information using combo boxes and date pickers. I would like to display a multiple line chart in another userform and have the ability to update every time a new set of information is added or taken away via the combo boxes.

So if I select a date range between 21/11/2008 to 11/11/2009 and then selected the criteria?s from zone 1, zone 2 etc and then clicked the show graph button, the new userform would pop up and display this information in a multiple line chart.

I would also have the ability to update the chart live, so if I went back to userform1 and selected another zone then the chart would update automatically to reflect this change.

If it is too much to ask for this chart to be displayed in another userform, then a multiple line chart in excel, embedded on a worksheet would be fine.

Thanks for your help.

kantian1
11-24-2008, 03:24 PM
Hi,

Anyone?

Thanks.

Kenneth Hobs
11-24-2008, 04:13 PM
Does the Data sheet contain a chart? I don't use 2007 so I may have lost something in the translation.

Some useful links:
To show 1 of 6 built charts on a userform.
http://peltiertech.com/Excel/ChartsHowTo/NameAChart.html

To change the series collection for a chart on the sheet from a combobox.
http://www.mrexcel.com/forum/showthread.php?t=354580

You can of course combine the 2 methods above.

kantian1
11-25-2008, 02:23 PM
Thanks for your help Kenneth.