From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Create chart titles from cell content

Create chart titles from cell content

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Create chart titles from cell content

- [Voiceover] We're in a worksheet called Chart Data over in Column T. We'd like to create a chart of just this data right here, and I'll press Alt F1. Now when you create a chart, usually you get a default chart title consisting of that very phrase. We might want to have a title down the left-hand side, and the easiest way to do this is on the contextual design tab that appears when a chart is selected, second button from the left, Quick Layout. As you slide over some of these choices, you'll notice that sometimes you'll see legends, sometimes you'll see titles on top, sometimes you'll see titles on top and on the left-hand side. I'd like to create a chart with the title on top and one down the left-hand side. But instead of actually typing, I'd like to pick up data that's on the worksheet itself. In Cell T1, that's a merge to cell is the text, Accelerated Learning Tools, the name of this company. And in Cell T2, that's also a merged cell. In no way is this a prerequisite for what we…

Contents