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.

Work with chart text

Work with chart text

From the course: Excel: Charts in Depth

Start my 1-month free trial

Work with chart text

- [Man] On this worksheet called chart text in our chapter four exercise file, I think most of us, upon seeing this chart, would say the fonts are way too big across the bottom. Also on the left hand side. We can individually click each one of these and make a change. But not so well known is the idea that we can change all the major titles at once on a chart simply by clicking in the chart area. That's the perimeter area on the chart. I'll click chart area. And then, on the home tab, there's the font size here. Click the drop arrow. And as I slide over the numbers, look at all the titles, both above and below, on the left and right side of the chart. The legend on the right, and so on. All these are changing at once. Suppose we start off with 12. That's pretty good for most of them. And while we're here, we could be making these bold. There's also the numbers down the left hand side on the vertical axis…

Contents