Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
Adding titles to charts can be a little tedious and even time consuming if you insist on typing them. However, you can pick up data from existing cells and put them in the chart titles. If you've created a chart, for example this one, and you don't have that kind of information, strong suggestion here is after having clicked on the Chart and activating the new Chart Tools Ribbon, on the Design tab the Chart Layouts feature, right here. Now, depending upon the chart type you'll see more or fewer entries here and if you haven't worked with these a whole lot, do take advantage of them.
Because they give you some built-in styles, and you will notice on some of them a gray bar on the top. That's space for a main title. Sometimes you'll see them down the left-hand side, sometimes on the bottom. So, we might pick one of these here, for example this one, and suppose we want to put in a title here, but why don't we use the data that's actually right here. This is actually in cell B1. In a chart, once you've chosen one of the Chart Layouts, click for example here under Axis Title. Then click in the formula bar, type equal, and then click on the cell that's got the data you want and then press Enter, and there we see the title there.
Similarly over here, now this might be a long title, we might want to reconsider, but still, Axis Title. We don't want to do any typing here. Click in the Formula bar, type equal, then this time click on cell A2 and press Enter. There it is. You have the ability and the right to type in anything you want, but why not take advantage of the fact that many times on the chart, the title that you want is likely to be embedded already in the data and why not take advantage of it, like we're doing here? And if we change our mind about the content of the title, possibly we might even change this cell, and it will be reflected in the chart immediately.
Maybe we don't use the word Company here that often and everybody knows that we are anyway. So, we might just click in here, maybe double-click and get rid of the word Company. You might even change the font size here too. Make it bigger and so on. Now, that didn't have any impact on the font size over here, so I might click here and then go into the Font group on the Home tab and slide across some of your choices here and watch that title grow. But take advantage of the fact that you can create titles by associating them with cell addresses within your worksheet.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.