Create Charts in Excel 2007 the Easy Way with Chart Advisor

Note: This article is part of our archive and is likely out of date.
(Links may not work, downloads have not been recently tested for safety)

By Brian Burgess on September 22nd, 2009

Creating charts in Excel spreadsheets is a great way to represent data in a visually appealing way, but can be too time consuming finding the appropriate one. 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.

Install Chart Advisor

Because this is an Office Labs prototype you will need to participate in Usage Metrics and Auto Update. Continue through the installation wizard to complete the process.

1-ca

After the installation is complete open Excel and you will see it under the Insert tab in the ribbon.

2-ca

Using Chart Advisor

Here we will take a look at using Chart Advisor. Open up an Excel spreadsheet and select the data you want to to create a chart on. In this example we’re using monthly sales figures for tools and supplies. After you have highlighted the cells click on Chart Advisor under the Insert tab.

4-ca

Give it an moment while Chart Advisor analyzes the data and recommends appropriate charts.

1-1ca

Hover over the different suggestions at the top to get a more detailed view of how it will look.

7-ca

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.

3-ca

Just hover the pointer over the percentage box on each suggestion to get a detailed formula of why it got its score.

5-ca

You can filter data to further modify the charts.

6-ca

You can further tweak the chart under Modify Chart and change data positions, exclude data, etc.

8-ca

When done configuring the chart just click the Insert Chart button to place it into the spreadsheet.

9-ca

If you are looking for a way to speed up how you create charts and graphs in your Excel presentations then you might want to check out this add-on.

Download Chart Advisor from Office Labs

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 09/22/09
More Articles You Might Like

Enter Your Email Here to Get Access for Free:

Go check your email!