From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use legends

Use legends

From the course: Excel: Charts in Depth

Start my 1-month free trial

Use legends

“

- [Instructor] Most Excel charts contain what we call a legend. You're probably familiar with the term. You also see it on maps, usually at the bottom of a map, or off to the right side. In charts, often you'll see a legend at the bottom. On this worksheet called Year Data in our Chapter 3 file, the column chart has a legend at the bottom explaining what the colors are. And off to the right, we've got a pie chart, and there too, same general idea. Each color there represents a different month. And what we see at the bottom, what color represents each month. Now, when you're applying these, or considering changing, one approach is to select the chart. I've just selected the column chart. Go to the Chart Design tab in the ribbon and consider changing chart styles. Now, sometimes you want to change the style and along the way, you might discover that legends can appear at the top. Most of these are on the bottom, but…

Contents