Help your chart communicate more effectively with preset styles, a descriptive title, and data labels.
Add a chart title
-
Select the chart, and then select the chart title.
-
Enter a new title.
Add data labels
-
Select the chart, and then select Chart Elements.
-
Select Data Labels.
-
Select the arrow, and then select a location and style for the labels.
To preview a location or style, pause over it.
Note: Options vary depending on the chart type.
Add axis titles
-
Select the chart, and then select Chart Elements.
-
Select Axis Titles.
-
Select the arrow, and then select the axis titles you want to add.
-
Select each axis title, and enter a label for it.
Apply a chart style
-
Select the chart.
-
Select Design, and then select a chart style.
To see how a style will look, pause over it
Want more?
In Office, you can customize the style and details of a chart to show everything you want.
To change the title, select the Chart Title, and type a new one.
To format the amounts in the chart, such as adding dollar signs.
Right-click the chart, select Edit Data, and Edit Data again and your data will appear.
Select the columns you want to format.
Right-click, and select Format Cells.
On the Number tab, select Currency and make sure the dollar sign is selected.
Choose how many Decimal places you want and select OK.
To show exact dollar amounts for each bar, select the chart and then select Chart Elements.
Select Data Labels to show exact amounts at the end of each bar.
To see more label placement options, select the arrow next to Data Labels.
To see a preview of centered numbers, pause over Center.
Select Inside End, which puts them inside the end of the bar.
To add a label near the dollar amounts at the bottom, select Axis Titles.
For the horizontal axis, add “In thousands.”
To remove the vertical axis title, select that box and press Delete.
To change styles, select Chart Styles.
Hover over each style to preview it.
Select one and your chart changes.
