LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
QuantumLeap
 
Posts: n/a
Default automatically plot points on chart

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plot roadmap chart in excel Dave Charts and Charting in Excel 0 November 21st 05 10:34 PM
Macro to Create a Chart and Update it Automatically maperalia Charts and Charting in Excel 2 October 21st 05 05:42 PM
Bar Chart To Line Chart for last 3 points only Big H Charts and Charting in Excel 1 October 13th 05 09:55 PM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Strange Problem with Chart and Plot Visible Cells Option Marcus Leon Charts and Charting in Excel 1 January 7th 05 03:52 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"