A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this tutorial, you will learn how to insert charts and modify them so they communicate information effectively. Each of Excel’s 12 chart types has different features that make them better suited for specific tasks. Pairing a chart with its correct data style will make the information easier to understand, enhancing the communication within your small business.
Before you start proceeding with this tutorial, we are assuming that you are already aware of the basics of Microsoft Excel. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel.
In Microsoft Excel, charts are used to make a graphical representation of any set of data. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart.
You can find the Charts group under the INSERT tab on the Ribbon.
The Charts group on the Ribbon looks as follows −
The Charts group is formatted in such a way that −
Types of charts are displayed.
The subgroups are clubbed together.
It helps you find a chart suitable to your data with the button Recommended Charts.
When you click on a chart, a new tab Chart Tools is displayed on the ribbon. There are two tabs under CHART TOOLS −
The Recommended Charts command on the Insert tab helps you to create a chart that is just right for your data.
To use Recommended charts −
Step 1 − Select the data.
Step 2 − Click Recommended Charts.
A window displaying the charts that suit your data will be displayed.