Firstly an apology if this has been asked for before, I have looked
through but am unable to find anything matching my request.

Each month I have to produce a report from our business system.
Primarily the report consists of many graphs.

I have created a report already that each chart references an
individual spreadsheet but the downloading from the business system
takes a couple of hours as each data set has to be individually
compiled and downloaded.
It is possible to download all the data in one go, but I am not sure
how I go about then linking the data to each graph.
Typically the individual downloaded data might be like this:-

Sales (Product A) data......
Stock (Product A) data......
Safety cover (Product A) data......
Production (Product A) data......

Whereas the multiple download would look like this:-

Sales (Product A) data......
Sales (Product B) data......
Sales (Product C) data......
Stock (Product A) data......
Stock (Product B) data......
Stock (Product C) data......
Safety cover (Product A) data......
Safety cover (Product B) data......
Safety cover (Product C) data......
Production (Product A) data......
Production (Product B) data......
Production (Product C) data......

There are a couple of complications in this.
1. I cannot guarantee that each month the order A, B, C, will remain,
maybe a new product would be added in the middle of the order.
2. The downloaded spreadsheet is overwritten each time it is
downloaded so I cannot write macros within it.

I think I need to do it with range names but I am not too sure on how
to write these into the graph series names. Before I start on this
project I need a steer on what direction I should take.

My level of Excel is not to bad, I can write basic macros if required.
If anyone can point me to a website where there maybe there are some
examples I could adopt or maybe send me a spreadsheet with a working
example.

I actually have had to split this out over three reports as I get an
error if I try to cram it into one spreadsheet. I think this is the
bug where there is more than 128 graphs in the spreadsheet.

We are running Excel 97.

Thanks in advance and maybe I can get a few brownie points from my
boss in solving this one.

John C.