Dynamic Excel charts 1

[drmichaelw]

I'm only a little bit familiar with vbscript, but is there a way to create a macro to graph my data. My table columns are (name, part,fab,totals,division and totals/part.)

I would like to create a different graph for every part.

The x axis would be fab and the y axis would be totals. I am creating about 120 graphs is there a way to loop through the data and create a graph every time the part changes?

The table is grouped by part which is text, fab is text and totals is a number.

Every month I get new data with the same columns however, the number of rows and row values will change each month.

Does anyone know how to code this?

 

[drmichaelw]

I forgot to mention that the excel data is comming from Access. My alternative would be to create the charts in access, and export them to excel.

I never used chart in Access.
Can anyone help with this alternative.

Please refer to my initial question.
Thank you.

 

[DODO1]

Hi,

Maybe this link :

http://www.meadinkent.co.uk/xlgraphoffset.htm

can get you started without the need of VB. Disadvantage is that you will have to create the 120 graphs yourself... but after that the offset function will take care of the dynamic.

DODO1