Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Need an Excel Chart? Try Chart Advisor

Posted by denglishbi on September 29, 2008

Creating visual representations of your data can sometimes be a challenge and you might get stuck in a rut using the same chart types over and over.  Why can’t you just select your data and let the tool generate the charts for you?  Well now you can.  Out on Office Labs there is a new product that is under development called Chart Advisor.  Once you have installed the product you will select the data in your Excel worksheet, click on the Insert portion of the Ribbon, and select the Chart Advisor in the Ribbon.  It will analyze your data (can experience performance issues with large amounts of data right now) and then present you with a good variety of chart options for you.  It currently doesn’t set the data types in the axis based on the data type in the spreadsheet (like currency and percentages), but other than that I think it is a great start.

Want to find out more check out this video on Soapbox:

Video: Chart Advisor Overview

And also check out the blog posting here on the Excel Team blog.

What are the requirements / limitations?
Operating System needs to be either XP or Vista. You’ll need a copy of Excel 2007. Also, because this is a prototype, we’re limited to 8,000 cells for analysis.

Check out more FAQ here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: