Dear who ever can help me!


I have to create a program in one or more excel sheets that draws up graphs from spesific fields in a data sheet and between a specified time.

Is it possible to do this using VBA?

There are 24 graphs that needs to be drawn up from one sheet using different fields of data for different periods all in one graphs. I have attached an example of the type of graph and the database used to draw the graphs.

One graph displays information for the different fields for quaterly, monthly and yearly averages.
I am unsure on how to filter the data in a dataset more than once and also how to program this in VBA to automize the process.

PLEASE help, any advice is welcome.

thank you
HeideneUntitled.jpgUntitled2.jpg