Friday, December 21, 2012

How to Add a Title to an Excel Chart


1. Start Microsoft Excel 2007 and open a spreadsheet that contains a chart to which you would like to add a title.
2. Click in the white area of the chart to select the entire chart. There should be a light blue outline surrounding the chart indicating that you have selected the entire chart.
3. Select the 'Layout' tab at the top of the Excel screen to display the layout options for the selected chart.
4. Click the 'Chart Title' button in the 'Labels' section of the 'Layout' ribbon. A drop-down menu will appear that will display the different locations that you can add a title for the selected chart.
5. Choose 'Centered Overlay Title' to add a centered title that lies on top of the existing chart so the chart does not have to be resized. Choose 'Above Chart' to add a centered title that goes above the chart and resizes the rest of the chart so it can fit.
6. Click the chart title you have just added to the chart and move the chart by clicking and dragging it to its new location. You must click on the outline of the chart with a 4-headed arrow before you can successfully move the entire title.

Blogger news