Which type of chart to use when? No worries. Excel will help you!

Lot has been written about it. With Excel 2013, Microsoft did the smartest thing. They added a chart type called Recommended Charts. Now Excel is smart enough to look at what data you have selected and choose the most appropriate chart types for you.

SNAGHTML17956f0

It shows the preview of those charts using YOUR data.

Final decision, of course, is yours. So you choose the one which depicts the information in the most relevant way. Also notice a feature called Recommended Pivot Tables.

image

The most important thing is to STOP using the habitually familiar chart and explore what recommendations are given by Excel. It is not about making the chart which someone is asking for.

It is about finding out every piece of useful information from available data and to use it to your advantage. By the way, that THOUGHT PROCESS is called Business Intelligence!

It is also a part of Quick Analysis feature (which we will cover in the next article).

One thought on “Which type of chart to use when? No worries. Excel will help you!

  1. Pingback: Microsoft and ET webinar | Efficiency 365

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s