Lesson 17 - Lesson 17: Editing Charts Page 1 By the end of...

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

View Full Document Right Arrow Icon
Lesson 17: Editing Charts Page 1 By the end of this lesson, learners should be able to: Change Chart Data Change the Chart Title Change the Data Series Names or Legend Names Change the Chart Type Page 2 Changing Chart Data When you add a chart to your worksheet, Excel creates a link between the chart and your source data. Any changes made to the original source data are automatically reflected in the chart. To Change Chart Values Directly in Worksheet Cells: Open the worksheet that contains the chart to be changed. Click in the cell whose value will change and type the new value. Press Enter to accept the new value. Page 3
Background image of page 1

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

View Full DocumentRight Arrow Icon
Changing Chart Data (continued) To Add Data to an Existing Chart: Rows or columns of data can be added to an existing chart by selecting the Add Data option on the Chart Menu. Input any new Source Data into the worksheet (e.g., a new column called South America). Click on the chart to select it for editing.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Lesson 17 - Lesson 17: Editing Charts Page 1 By the end of...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online