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.

Link titles to content

Link titles to content

From the course: Excel: Charts in Depth

Start my 1-month free trial

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