From the course: Excel: Charts in Depth

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Link titles to content

Link titles to content

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

Link titles to content

“

- [Instructor] When you create a new chart, or when you're working with an existing chart, you might want to tie a title to actual sell content within a worksheet. I'm going to create a new chart by selecting the data on this worksheet called Profits 2020. Highlighting cells A3 over and down to G6. I'll press Alt F1. There's the chart. For chart title I want to use the data that's in cell A1, now that happens to be a merged cell, that is not a prerequisite, not a detriment either, of course. I'll simply click the chart title box type Equal and click cell A1. Because it's a merged cell I can click anywhere in that blue panel, there it is. You see in the formula bar what's happening I'll press Enter, and there we have it. Now I might want to titles down the left hand side too. We don't see them here the easiest way probably would be on the Chart Design tab second button from the left, Quick Layout,…

Contents