Uses of Recommended charts in Microsoft Excel

In this article, we are going to learn about recommended charts in Excel. What is the use of a recommended chart? Where we can make use of it?

What is the use of recommended chart?

It is the most useful and automatic data analysis functionality in Excel 2013. When you don’t know which chart you should use, you can take advantage of this option in Excel. You just need to select the data and click on recommended chart.

You can find this option: – Insert tab > Charts group >Recommended Charts

 

image 1

 

How can we use Recommended chart?

To understand the use of Recommended chart, we will take an example.

We have agent’s data with the number of sales detail. Now we want to show the number through graphical image, but we don’t know which chart will be appropriate.

 

image 2

 

To choose the suitable chart, we can use the Recommended chart. Follow below steps:-

  • Select the data range

 

image 3

 

  • Go to Insert tab > Under Charts group > Click on Recommended charts
  • Insert Chart dialog box will open, and in the left side of the dialog, you can see three recommended charts

 

image 4

 

  • Now you can see Excel has recommended for Column and Bar chart which is technically correct because to show the values we also use column or bar chart
  • Click on ok
  • Chart will get inserted in the sheet

 

image 5

 

Now let’s take another example to understand more about Recommended chart of Excel.

We have Product list with the detail contribution %age in total sales.

 

image 6

 

Follow below steps:-

  • Select the data range

 

image 7

 

  • Go to Insert tab > Under Charts group > Click on Recommended charts
  • Insert Chart dialog box will open, and in the left side of the dialog, you can see three recommended charts

 

image 8

 

  • Now you can see in the above image that recommended chart has changed according to the data
  • Click on Pie chart and Click on OK

 

image 9

 

Conclusion: – Whenever you are confused in selecting the appropriate chart, take the help of Recommended chart. It will recommend you appropriate chart, for sure.

 

image 29

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube