Tag Archives: Data Visualization

How to create Custom Data Labels in Excel Charts

I received a query from a customer about dynamic data labels for charts. Instead of replying directly, I thought of writing this article. This will help all of you in refining your charts. The idea is to create a chart which explains the fluctuations using text based explanations. The best part is, the explanation can be a part of the data itself.
Watch the two minute video and read details below. This works with Excel 2013 onwards. I have also included the solution for older versions, which is not as elegant, but it works.

Continue reading How to create Custom Data Labels in Excel Charts

Power BI Desktop course – Need your inputs

Power BI is powerful, as the name suggests. But it is also confusing. Exactly what what does Power BI mean? There is no simple, single line answer. Let me try. It is a set of new tools to analyze old data in new ways. Today the simplest way to get started it to sign up for a free Power BI subscription and use Power BI Desktop tool to create your reports and dashboards. I have already written an introductory article and published a walkthrough video.

Power BI Desktop course on Udemy

I feel this is one tool which can transform the way we work on data and analyze it. The primary reason is that it is independent of Excel. So all the bad habits which we have developed in Excel over decades simply disappear! I am planning to create a course on Udemy for Power BI Desktop. I would like your inputs on the content and any additional ideas or wish list. Read on to have a look and post your comments. You can also send a mail to me on nitin@maxoffice.biz

Continue reading Power BI Desktop course – Need your inputs

In-depth: Excel Recommended Charts

Now that we know about Excel Recommended Charts, let us explore it in-depth. This is an implementation of artificial intelligence or machine learning at your fingertips. Don’t underestimate it… exploit it.

Excel recommended charts

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

Continue reading In-depth: Excel Recommended Charts

Don’t just make charts the way boss wants. Use Recommended Charts

There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are blindly created billions of times everyday – why? Because boss wants it that way!

In this article, I am going to attempt to change the mindset of all users of Charts. Please spend 5 minutes of your time reading this article and trying out a new thought process. I am confident that it will add value to your life.

Excel Recommended Charts

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

Continue reading Don’t just make charts the way boss wants. Use Recommended Charts

New, better alternative to Pie Charts: Treemap

We have been using Pie Charts for decades. Although these are useful for looking at proportions, there are disadvantages. Now, we have a more effective and easier to interpret chart available in Office 2016 – Treemap. What’s more, this chart is available for all devices – including mobile phones!

TreeMap - better than Pie Charts

Continue reading New, better alternative to Pie Charts: Treemap

Caution: Visual Interpretation Error in Data Analytics

We have seen how to put data bars in Excel (Bar charts with a difference). These help us compare any value with any other value visually. This helps us understand patterns in the data.

example for Visual Interpretation Error

If not used properly, this great feature can lead to confusion and misinterpretation as well. Here are common scenarios and the solutions.

Continue reading Caution: Visual Interpretation Error in Data Analytics

Quick Analysis should NOT be done quickly!

Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real benefit – as usual – is elusive and difficult to grasp in this “instant” mode of living life.

Quick Analysis

Read on to find out what you are missing – even if you know how to use Quick Analysis!

Continue reading Quick Analysis should NOT be done quickly!