Data Analysis with Microsoft Excel: Updated for Office 2007

88 Excel By observing the placement of the points on the scatter plot, you can get a general impression of the relationship betw ...

Chapter 3 Working with Charts 89 To insert a chart: 1 Select the cell range D1:E12. 2 Click the Scatter button from the Charts g ...

90 Excel Once you’ve created the basic scatter plot, you can format its appearance using the commands on the Chart Tools ribbon. ...

Chapter 3 Working with Charts 91 c. Click the Edit button within the dialog box, and then select a different data range for the ...

92 Excel Figure 3-8 Moving an embedded chart Around the selected chart object at the four corners and four sides are selection h ...

Chapter 3 Working with Charts 93 selection handle Figure 3-9 Resizing an embedded chart Moving a Chart to a Chart Sheet To move ...

94 Excel 3 Click the OK button. As shown in Figure 3-11, the chart is moved to a chart sheet named Graduation Chart. Move Chart ...

Chapter 3 Working with Charts 95 To change the chart title: 1 Click the Graduated title located directly above the scatter plot. ...

96 Excel Layout tab Chart Title and Axis Titles buttons x axis title y axis title Figure 3-13 Inserting axis titles The chart an ...

Chapter 3 Working with Charts 97 EXCEL TIPS You can also use the format buttons on the Home tab to change the font color, font s ...

98 Excel 4 Click the Fixed option button for the Axis maximum and enter 1500 in the accompanying text box. 5 Click the Fixed opt ...

Chapter 3 Working with Charts 99 Now the data points are only compressed near the top of the chart. You can change this by setti ...

100 Excel axis scale goes from 50 to 100 in steps of 5 Figure 3-16 Revised scale for the y axis EXCEL TIPS You can display the a ...

Chapter 3 Working with Charts 101 To add vertical gridlines: 1 With the chart still selected, click the Gridlines button from th ...

102 Excel To remove the legend: 1 Click the Legend button from the Labels group in the Layout tab of the Chart Tools ribbon and ...

Chapter 3 Working with Charts 103 5 Click the Marker Fill tab and then click the No fi ll option button. 6 Click the Close butto ...

104 Excel EXCEL TIPS Excel has several different built-in chart layouts for making quick changes to several chart objects at the ...

Chapter 3 Working with Charts 105 rates. That’s not surprising, but there are a couple of exceptions to that relationship. For e ...

106 Excel percentage? One way to fi nd out is to compare the values given in the pop- up label with the values in the worksheet. ...

Chapter 3 Working with Charts 107 5 Click cell A1 to remove the highlighting. Labeling Data Points You can also use the StatPlus ...