If the data is contiguous, you can select a single cell in the range, and
Excel will expand the selection until it comes to empty rows and columns. To
make sure the Date column is used for X values, delete the label Date in the
top left cell. That's right, completely clear the cell: select the cell and
press Delete. This blank cell helps Excel to parse the data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"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.