Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.
Chart and layout style
After inserting a chart, there are several things you may want to change about the way your data is displayed. It's easy to edit a chart's layout and style from the Design tab.
- Excel allows you to add chart elements—such as chart titles, legends, and data labels—to make your chart easier to read. To add a chart element, click the Add Chart Element command on the Design tab, then choose the desired element from the drop-down menu.
- To edit a chart element, like a chart title, simply double-click the placeholder and begin typing.
- If you don't want to add chart elements individually, you can use one of Excel's predefined layouts. Simply click the Quick Layout command, then choose the desired layout from the drop-down menu.
- Excel also includes several chart styles, which allow you to quickly modify the look and feel of your chart. To change the chart style, select the desired style from the Chart styles group. You can also click the drop-down arrow on the right to see more styles.
You can also use the chart formatting shortcut buttons to quickly add chart elements, change the chart style, and filter the chart data.