Pretty graphics in a chart may look nice at first, but graphics alone seldom convey the entire message desired. Without titles, many charts would be cryptic at best and useless at worst. Titles add purpose and meaning to your chart. Excel allows you to add several different types of titles.
You should note that the titles available for any given chart will vary, depending on the type of chart you are using. For instance, the only type of title available with a pie chart is the chart title itself. Since there are no X, Y, and Z axes on a pie chart, there are no titles available for them.
To insert titles, follow these steps:
To change the text contained within a title, you can always follow these same steps again. There is an easier, more direct way to change title text, however. All you need to do is click on the title. The title is selected and surrounded with a box and handles. When you move the mouse pointer inside the box, it changes to an insertion point. Click the mouse pointer once to edit the text.
Notice that if you press Enter, the cursor only moves to the next line; you are still adding to the title. To signify that you are finished entering title text, you must use the mouse pointer to select some other part of your chart or worksheet.
When you add titles to your chart, Excel places them in a position it feels is best for the title. Thus, an axis title will be centered on the axis. You can move titles very easily, however. To do this, use the mouse to select the title text. When you do, it becomes surrounded with a box and handles. Use the mouse to point to the border around the title. Press and hold down the mouse button. As you move the mouse, the title is also moved. When you release the mouse button, the title remains at the new location.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6609) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Using Chart Titles.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
One type of chart that Excel allows you to create is one that occupies an entire worksheet. When it comes time to print ...
Discover MoreUnhappy with the default size that Excel uses for embedded chart objects? You can't change the size at which they are ...
Discover MoreMost charts you create in Excel are based on information stored in a worksheet. You can also create charts based on ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-04-19 04:43:45
Worth adding that if you want a chart title to be dynamic (i.e. based on a formula), you can't do this directly, but you can enter the formula into a helper cell in the sheet, and then reference the title to this cell. To do this, click on the chart title, then click in the formula bar, type = and then click on the helper cell and press Enter.
2017-04-18 05:02:32
Peter Burke
Probably worth mentioning that the title of a chart can be variable.. e.g. instead of typing text in the column title enter "=a2" in the formula bar.
The chart title will be whatever is in A2... which in itself is just a normal cell to enter formulas etc.. So the chart title can be as sophisticated as you want it to be
2017-04-15 15:51:18
Gary
It would be helpful to see the macro instructions to set up chart titles and axis titles.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments