Chart Advisor

Who said that we need to be an expert in Excel to create a professional chart in order to visualize our data?

I believe we have all wasted so much time to find the right chart in order to represent out data in the best way possible. Well this is where the Chart Advisor shows up.

Chart Advisor was created so Excel users can create graphs quickly and effectively. Depending on our data on the Worksheet, it identifies, ranks and displays charts that are mostly relevant to our data in order to create the most appropriate chart. The Microsoft Office Labs has done a successful job once again.

In order to download the Chart Advisor we must follow the address below:

http://www.officelabs.com/projects/chartadvisor/Pages/default.aspx

Requirements: 32-bit Windows XP or Windows Vista. Excel 2007.

Limitations: English only. Analysis limited to 8,000 cells.

For this Post I have installed it on Windows 7 Home Basic and Office 2007 Greek.

Once downloaded, we run the executable file ChartAdvisorSetup.exe in order to install it, where the Chart Advisor Setup window appears.

01

We accept all the privacy policies, until we reach to last window of the setup installation where we are informed that it was successfully as shown in the image below.

04

Now all we have to do is to start Excel, and input all our data that we want represent in a chart. Once we have done we make sure that we have selected the data in our spreadsheet and then weselect the Insert Tab and from the area of the ribbon named Office Labs we select the Chart Advisor button as we can see in the image below.

05a

Straight away the Chart Advisor from Microsoft Office Labs window appears, showing us the best five charts that our data can be represented in, created in seconds.

The first one is the Radar chart as we can see in the image below, and in the middle of the window we can see a preview of how our data will be represented. If we are satisfied with the result we just press the Insert Chart button at the bottom right of the window.

05

The second one is the Pie chart as we can see in the image below, and in the middle of the window we can see a preview of how our data will be represented. If we are satisfied with the result we just press the Insert Chart button at the bottom right of the window.

06

The third one is the Clustered Columns chart as we can see in the image below, and in the middle of the window we can see a preview of how our data will be represented. If we are satisfied with the result we just press the Insert Chart button at the bottom right of the window.

07

The fourth one is the Clustered Bar chart as we can see in the image below, and in the middle of the window we can see a preview of how our data will be represented. If we are satisfied with the result we just press the Insert Chart button at the bottom right of the window.

08

The fifth one is the Line chart as we can see in the image below, and in the middle of the window we can see a preview of how our data will be represented. If we are satisfied with the result we just press the Insert Chart button at the bottom right of the window.

09

At the left of the Chart Advisor window we can either Modify our Chart or we can Filter the Data by selecting the appropriate button. In the image below we can see that we have chose the Filter Data button and then at the top of the Filter Data window we can select or deselect days of the week depending on the data that we have.

10

In the image below I have now selected different data from a worksheet and selected the Chart Advisor button. The Chart Advisor window appears, and as we can see it suggests different sorts of charts at the top row. Then from the left area of the window I have selected the Modify Chart button, and from the Modify Chart area we can do all the settings that we want to for our chart.

11

Whatever settings we do we have to press the Update Chart button that appears in order for the changes to be applied or to press the Undo Changes button to undo all the settings.

12

Once finished we press the Insert Chart button, and straight away our chart has been inserted into to our worksheet as we can see in the image below.

13

Once the chart is inserted we can still modify it, change the layout or format it in order for our chart to look the best way as possible.

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 December 1, 2011, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Chart Advisor.

Comments are closed.