From the course: Excel 2016 Essential Training

Unlock the full course today

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

Formatting charts

Formatting charts

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Formatting charts

- When you create a chart in Excel, many of the chart elements are all in place and practically ready for presentation. As I highlight the data here in this worksheet called Formatting Charts, I can create a chart quickly with alt F1, or if I want a chart on a separate sheet, the F11 key, or going by way of the Insert tab in the ribbon, I can go to Recommended Charts, possibly pick one of the other buttons in the background, focus on the chart type I want, possibly this one. I like that best. Click OK. Got a chart. We've got a legend either on the right side or below it. It explains what the colors stand for. Beneath each cluster of columns we see a region name. That works fine. Chart Title is not something we want to keep. We might want to explain the numbers down the left-hand side, so, what's missing here? You could make the case for saying just two things, a main title on top, a title down the left-hand side. One approach is, click Chart Title, type in whatever we want. That's…

Contents