A chart is a visual representation of your data. By using elements such as columns (in a column chart) or lines (in a line chart), a chart displays series of numeric data in a graphical format.
The graphical format of a chart makes it easier to understand large quantities of data and the relationship between different series of data. A chart can also show the big picture so that you can analyze your data and look for important trends.
Select the data that you want to chart.
Tip The data should be arranged in rows or columns, with row labels to the left and column labels above the data — Excel automatically determines the best way to plot the data in the chart.
On the Insert tab, in the Charts group, click the chart type that you want to use, and then click a chart subtype.
Tip To see all available chart types, click to launch the Insert Chart dialog box, and then click the arrows to scroll through the chart types.
When you rest the mouse pointer over any chart type, a ScreenTip displays its name.
For more information about any of the chart types, see Available chart types.
Use the Chart Tools to add chart elements such as titles and data labels, and to change the design, layout, or format of your chart.
Tip If you don't see the Chart Tools, click anywhere inside the chart to activate it.
- To get a good idea of what you can add to or change in your chart, click the Design, Layout, and Format tabs, and then explore the groups and options that are provided on each tab.
- You can also access design, layout, and formatting features that are available for specific chart elements (such as chart axes or the legend) by right-clicking those chart elements in the chart.
- For step-by-step instructions to create a chart, see Create a chart from start to finish.
Top of Page