Exam 77-882: Microsoft Excel 2010 Core

6. Presenting Data Visually

6.1. Create charts based on worksheet data: Modify the Layout

Modify the Chart

A chart should tell the story in 3 seconds or less. The Chart Legend is not the most effective way to teach the numbers. It is "one step away" from your data. In our example, the legend is redundant. You can use the Chart Tools to remove the Legend.

 

2. Try it: Remove the Legend

Select the Chart and go to Chart Tools.

Go to Layout->Labels-> Legend.

Select: None.

 

 

Keep going...

Chart Tools -> Layout -> Labels-> Legend