This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Next Previous Section 3.6: Plotting Data—Part II Section 3.6: Plotting Data—Part II 11 ® Adding a second plot to a graph ® Using the Trendline feature Section 3.6: Plotting Data—Part II Next Previous Section 3.6: Plotting Data—Part II Section 3.6: Plotting Data—Part II 22 1. Add a second set of data –> z = a + bx Start a column for a new dependent variable, z ® Enter a formula for z ® =a + b*B4 in cell F4 ® Copy the formula from cell F4 ® Paste it into cells F5 to F13 Adding a second plot Next Previous Section 3.6: Plotting Data—Part II Section 3.6: Plotting Data—Part II 33 2. Choose the second data set as S ource Data Adding a second plot Next Previous Section 3.6: Plotting Data—Part II Section 3.6: Plotting Data—Part II 44 The scale for the z variable is too small Recommended Changes for the Z plot • Different color ( blue ) • Larger symbol size • Larger axis scale, using “secondary axis” 3. Showing a secondary axis and improving the formatting Adding a second plot • Graph is moved to a separate sheet • Have restored the legend Next...
View
Full Document
 Spring '08
 ALL
 Typeface

Click to edit the document details