Excel: Work Smarter (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

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. You can use the Chart Tools to remove the Legend.

 

Try it: Remove the Legend

Select the Chart and go to Chart Tools.

Go to Layout->Legend.

Select: None.

 

 

Keep going....when you remove the Chart Legend, you need to add Data Labels so that your Chart makes sense.

Chart Tools -> Layout -> Data Labels

 

  Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually

  4.2. Modify charts  4.2.1.  Add and remove chart elements: Legends