drmichaelw
IS-IT--Management
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?
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?