# Ch3_6 - Next Previous Section 3.6 Plotting Data—Part II...

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 Document

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.

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

{[ snackBarMessage ]}

### Page1 / 11

Ch3_6 - Next Previous Section 3.6 Plotting Data—Part II...

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

View Full Document
Ask a homework question - tutors are online