2001XLScatterPlotMono

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

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

View Full Document Right Arrow Icon
1 Creating an Excel XY (Scatter) Plot E XCEL R EVIEW 2001-2002
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

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 Right Arrow Icon
Ask a homework question - tutors are online