{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

2001XLScatterPlotMono

# 2001XLScatterPlotMono - Creating an Excel XY(Scatter Plot...

This preview shows pages 1–4. Sign up to view the full content.

1 Creating an Excel XY (Scatter) Plot E XCEL R EVIEW 2001-2002

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2 What is an XY or Scatter Plot? An XY or scatter plot either shows the relationships among the numeric values in several data series or plots two groups of numbers as a single series of XY coordinates. It can show uneven intervals or clusters of data and is commonly used for scientific data. Example of an XY Scatter Plot The data and plot below are an example of an using an XY or scatter plot to show relationships among several data series. This example shows the relationship between time and two temperature values. Time is the X value on the horizontal axis. There are two data series for the Y values: Actual temperatures and and predicted temperatures. Time Temperature 8:01 23 21 8:25 23 22 9:01 24 22 9:25 26 23 10:01 28 25 10:25 28.5 26 11:01 29 27 11:25 29.3 27 12:01 32 28.5 12:25 32 29.2 13:01 35 30 13:25 35.5 31 Time & Temperature 0 10 20 30 40 7:10 9:34 11:58 14:22 Time Actual & Predicted Temperatures Temp Predicted Temp When you arrange the data for a scatter plot, place x values in one row or column and then enter corresponding y values in the adjacent rows or columns. In the data shown at left, for example, values with the label “Time” are the x- axis values. The “Temp” and “Predicted Temp” values are Y values.
3 Time and Temperature 0 5 10 15 20 25 30 35 40 8 :0 1 :25 9 0: 01 0:25 Time & Temperature 0 5 10 15 20 25 30 35 40 :01 9: 0 2 5 10:01 1:01 : 12:25 13:01 3:25 Temp Predicted Temp What Happens If You Select the Wrong Chart Type for Your Data Excel offers many different chart types and in many cases you can substitute one type for another with no loss of meaning. However, the XY scatter plot is a unique type of plot because of the way it treats data. You might select a chart

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

2001XLScatterPlotMono - Creating an Excel XY(Scatter Plot...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online