Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
You can control the style of a font, size of the font, and all chart text within a chart either all at once, in other words all the text entries on a chart, or simply one portion at a time. Most of these shortcuts are available by right-clicking, but even faster, much of the time, will be standard tools that you're familiar with on the Home tab of the Ribbon. In the worksheet on the left, perhaps I want to change the main title. I'm just going to click on it, and the Home tab of the Ribbons is active. I want to change the font, possibly. It will overlap the title, but I can still see here a portion of it, and as I'm sliding over this choices, you see the title just to the right there changing based on these many, many different font possibilities.
Once again the wealth of choices is astounding here, and Excel's so-called Live Preview really helps, so I'm not clicking and we can get through this list pretty fast, although we really don't get through it, but just to see what some of these choices offer us. If we like this one, that one, we'll stop, click it, fine. Something like that. Now I changed just the main title, didn't change the Legend. Possibly we could over there and make it change to the Legend, maybe something different over there, maybe not. Same general idea of course. I could change there, and similarly with Size. And I can say this are great choices, but anyway, just to make the point, if I want the labels across the bottom to be of different font--and I wouldn't suggest multiple fonts is a good idea. In fact, most books on Excel charting suggest that you keep the fonts to at most two variations within a chart, certainly not 3, 4, or 5.
Now what if we wanted to change all text within the chart, and we can then from there change our mind about this portion of it or that portion of it. If you click in that portion of the chart called Chart Area--that's the outer portions, just click there-- if you make a font change, I'm going to go back to Calibri here, that changed all the text--top, bottom, left, right--on this chart. And if I click the drop arrow for the font size here. I'm going to choose 16. As I'm sliding over these, you'll see what's happening in the background.
I'm about to change all of these. So sometimes you might use this as a starting point. Maybe 16 is not quite right. 14 looks pretty good for most of these. But on the other hand, you want the main title to be bigger. Click right here, choose a different font size there. Now you can also right-click to get into these, but when you do right-click-- suppose I want to change the legend over here on the right-hand inside. I'm going to right-click on the legend and possibly instead of going to Format Legend, because if you go here you won't see font size changes, nothing about the size of the font or the font itself, but you may have noticed when I did that right-click there was another choice called Font.
So I could go down this path here, and you might not have seen this one before. We can change the Size here. We can make some choices here. Now this doesn't give us the so-called Live Preview features, so I don't think this is as good. We're not seeing what the font looks like ahead of time. Add another choice you might have noticed here, when I right-click here again the Mini tool bar appears, so I've got some choices here too. And here we see some font choices. Now, on these two we're not seeing Live Preview, but if you know exactly which font you want, that's another approach.
So did we give you enough ways here to make text changes? I think so. It's easy. It's fast. I recommend the Home tab because you do have Live Preview in all cases. It's fast and it's easy. So great ways to make font changes within different parts of the chart or throughout all text on the chart at the same time.
There are currently no FAQs about Excel 2007: Charts in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.