Recommended Charts in Excel 13

Remember Chart Advisor, a previous post which I mentioned about an application that we could install in Excel in order to help us create a professional chart, in order to visualize our data by using the recommended charts?

Now with Excel 13, this feature is already available, so we don’t have to bother downloading it and installing it. The people from Microsoft Office Labs had done a good job with the Chart Advisor and probably it inspired them to include it in the new version of Excel.

What do we need to use this feature? Of course data.

First of all we must select the data that we want to visualize in a professional chart. Then if we are not sure which chart to use we can use the feature Recommended Charts. We must select the Insert tab and then from the area of the ribbon named Charts we select the command Recommended Charts as shown in the image below.


Once we have selected the Recommended Charts command, the Insert Chart dialog box appears. The Recommended Charts tab is activated at the top left area of the window as we can see below. Depending on the data in our worksheet, the most relevant charts for use, are displayed right below, and at the right area of the window we have a large preview of the selected chart with a thorough description below.


We can click on any small preview of the Recommended Charts, all of them displaying their description in order to decide which chart we are going to use.  Once we have decided, all we have to do is to select it and click the OK button at the bottom right area of the window and the chart will be inserted in the spreadsheet as we can see in the image below.


If the data selected can’t be visualized in a chart, by using the Recommended Charts command the Insert Chart window will appear displaying the following message:

“Recommendations are not available for the data you selected. To choose a chart type, click All Charts”

Followed by all the possible reasons that the chart cannot be displayed as we can see in the image below.


In the next post I will continue to describe other new features in Charts, such as the small icons next to our selected chart.


Below you can check out the video describing the new feature Recommended Charts.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on October 8, 2012, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , . Bookmark the permalink. Comments Off on Recommended Charts in Excel 13.

Comments are closed.