Author: Oscar Cronquist Article last updated on October 16, 2018


Charts in Microsoft Excel lets you visualize, analyze and explain data.

Charting in Excel is very easy and you will be amazed how quickly you can produce a clear visual representation of your data.

This article explains the different elements that exist in the most popular Excel charts.

The links to the right allow you to quickly move to a section in this article.

Check out the 'Chart Basics' category for more tips and tricks.

Chart area

The chart area contains all chart components. Read more here: Chart area

Chart title

The chart title is often a descriptive text of what the chart displays. Read more here: Chart title

Plot area

The plot area refers to the location of the chart that shows the actual data represented by lines, bars, columns, dots etc.

Read more: Plot area

Axis titles

The x-axis and y-axis titles are easy to format and customize, read more here: How to customize chart axis titles

Axis values

The axis values are also easy to customize, read more here: How to format chart axes and their values

Chart series

Read more here: How to customize a chart data series

Back to top

Legend

Read more: How to customize the chart legend

Tick marks

Read more: How to customize chart tick marks

Final words

There is a really quick way to add chart elements, simply select the chart.

Click the "plus" sign and all chart elements show up. Select or deselect the elements you want.

Back to top