, ,

45. Introduction to Excel Charts

Want create site? Find Free WordPress Themes and plugins.

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.

Charts Group

You can find the Charts group under the INSERT tab on the Ribbon.


The Charts group on the Ribbon looks as follows −

Charts group

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.

Chart Tools

When you click on a chart, a new tab Chart Tools is displayed on the ribbon. There are two tabs under CHART TOOLS −


Chart Tools

Recommended Charts

The Recommended Charts command on the Insert tab helps you to create a chart that is just right for your data.

Recommended Charts

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.

Using Recommended Charts

Did you find apk for android? You can find new Free Android Games and apps.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.