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
From the course: Excel 2016: Tips and Tricks
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.