Excel Graphing Help - 2003

[minendo]

Currently I have a database that contains 13 difference locations with 6 attributes each. All data is input in the following columns:

Date
Time
Result
Location
Attribute
UCL
LCL
Target

Now what I am trying to do is take the data and graph in a total of 96 different graphs, but I want this done automatically as I do not want to have to sort through all the data and click and drag ranges.

Graphs need to display the following:

Date and Time on x-axis
Result Range on y-axis
4 total lines (UCL, LCL, Target, and Result)

Is there any way to do this?

 

[Anubis]

yes write a macro

lazy mans way is to do it manually once and then save it as a template. provided the data range is always the same the graphs will auto populate when you copy/paste new data

 

[minendo]

yes write a macro

lazy mans way is to do it manually once and then save it as a template. provided the data range is always the same the graphs will auto populate when you copy/paste new data

Data range is different for each attribute and location though.