This preview shows pages 1–5. Sign up to view the full content.
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 DataPart II Section 3.6: Plotting DataPart II 11 Adding a second plot to a graph Using the Trendline feature Section 3.6: Plotting DataPart II Next Previous Section 3.6: Plotting DataPart II Section 3.6: Plotting DataPart 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 DataPart II Section 3.6: Plotting DataPart II 33 2. Choose the second data set as S ource Data Adding a second plot Next Previous Section 3.6: Plotting DataPart II Section 3.6: Plotting DataPart 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

Click to edit the document details