The simple answer to your questions is Yes if you know VBA.

With a combination of dynamic range names, advanced filtering and VBA,you
can create macros to generate new charts each time period.

How are your VBA skills?

I suspect you want to know how. That is a little more involved.

The first item is your data organization. Data organization is the most
important factor in automatic generation of multiple chars. you will need
to loop through your data to generate charts by measurement and series by
data-collector. Your example data set shows three measurements, you don't
give any indication of the number of data_collectors. More than 3-5 series
per chart makes it hard to interpret series data.

Also, you don't indicate how many files you are dealing with and the sheets
per file.

For the chart time period, do you want to be able to plot just the last X
days of data, all data or user specified period?

I have an example workbook that makes 8 charts on 1 sheet. Each chart only
has one series. it may give you some ideas on how to proceed.

Let me know if you need any follow-up help.

http://processtrends.com/pg_charts_s..._XY_Charts.htm

....Kelly








"QuantumLeap" wrote in message
...
I have files that contain measurment information that has rows in the
following format:

Date Data_Collector Measurement_A Measurement_B Measurement_A

where the measurements are taken at different locations.

There are multiple rows for different dates and data collectors and the
amount of information in the file varies by how many measurements were
taken
in each given stretch of time.

My question is, is there a way for me to have Excel automatically plot all
of the data in the file? I would like different charts for the different
measurements, where the x-value is the date, the y-value is the
measurement
value, and there are different series for each data collector.

I have been doing this by selecting the data myself, but that gets to be
very time-consuming.

Thank you.