Hello,

I have tried a few different methods to try and generate charts on my data
set. The data set is dynamic but I'm sure it can be formatted to fit the
series of charts I want to generate.

I created an Access Database that pulls outstanding jobs data from our
Production Database System and imports it into Excel. Here is the format
it's being imported in as:

ColA ColB ColC ColD ColE ColF...etc
Year Week AReq AIss BReq BIss...etc
2006 51 2.7 1 23 10.5...
2007 2 5 3.1 9.3 8.9...
....

There are about 50-60 columns and the amount of rows are broken down by
weeks in the year. I had broken it down like this, but changed the format
because I thought it would be easier on generating a graph per row.

Old Format:

ColA ColB ColC ColD ColE
Year Week Machine Req Iss
2006 51 CNC1 2.7 1
2006 51 CNC2 23 10.5
2006 51 L1 8 6
2007 2 CNC1 5 3.1
2007 2 CNC2 9.3 8.9
2007 2 W1 25 15.7
....

This data can change daily. I would like to generate a chart per
spreadsheet for each week. Also would like to put the Machines along the
x-axis and hours along the y. I thought I could put both the required and
issued hours beside each other for each machine but not sure how to do that
with my newer format. I would like to force the data to update on the first
page and the charts to generate on additional spreadsheets (macro is run off
a button on my Database). Any help on this would be appreciated. Been
working at it for a few days now... and it's getting frustrating.

---Achilleas