Today we take a look at Chart Advisor from Microsoft Office Labs which makes the process more efficient.
Note: Remember this is a prototype and under development and may not work perfectly with your system.
Continue through the installation wizard to complete the process.
After the installation is complete open Excel and you will see it under the Insert tab in the ribbon.
Using Chart Advisor
Here we will take a look at using Chart Advisor.
Open up an Excel spreadsheet and go for the data you want to to create a chart on.
In this example were using monthly sales figures for tools and supplies.
After you have highlighted the cells tap on Chart Advisor under the Insert tab.
Give it an moment while Chart Advisor analyzes the data and recommends appropriate charts.
Hover over the different suggestions at the top to get a more detailed view of how it will look.
The amount of charts you have to choose from will be determined by the data cells you select.
Also notice they are sorted by relevance.
you’re able to filter data to further modify the charts.
you might further tweak the chart under Modify Chart and change data positions, exclude data, etc.
When done configuring the chart just hit the Insert Chart button to place it into the spreadsheet.
Download Chart Advisor from Office Labs
