Charts provide an easy-to-assemble but clear and persuasive illustration of your data. Excel offers a variety of charts in both two-dimensional and three-dimensional formats. Default features, however, may not provide the look and include all of the data you wish to be displayed. One common functional need of a chart is a chart title.
- Once you have your raw data in an Excel chart, select the Chart Area. Chart Tools contextual tabs (Design, Layout and Format) appear above the ribbon and allow you to alter your chart options.
- Option 1: Under the Design tab, in the Chart Layouts group you can choose from several layouts that create a chart title. Once you have selected the desired default, you can alter the Chart Title textbox.
- Option 2: If you are interested in customizing the location and alignment of your Chart Title, choose the Layout tab.
- In the Labels group, choose the Chart Title button to add, remove or position the chart title. Three options become available.
- If you are interested in more title and alignment options, choose More Title Options.
- The Format Chart Title dialog box appears. Select the Alignment tab.
- Under Alignment you can change the vertical alignment, angle and text direction to better customize your chart. Play around with the chart features to get many looks.