All articles with 'charting' Tag

Over the weekend I spent some time to update the Excel Dashboards page. It now features more articles, downloads and resources for those of you making Excel Dashboards. Go ahead and check out the page here and let me know your feedback.

Moving on to this weeks excel and charting links worth checking.

This week’s poll is very simple. What is the the most embarrassing charting mistake your made?

For me it has to be that one time when I made a sports dashboard using excel. I have adjusted the axis scale of a bar chart so that my favorite cricket player (Sachin Tendulkar, who else?)’s records are emphasized. In a matter of minutes I have received several comments from all over world pointing out the mistake. Even though, the intention was to highlight the achievements of master blaster, the axis adjustment was obviously a mistake.

Aravind (@arvindnatarajan on twitter) who works at Zoho emailed me earlier today and asked if Zoho Reports – Online Reporting and Business Intelligence Service, can sponsor our visualization challenge #2.

Two charting principles we hear all the time are,

• Sort your data in a meaningful order before plotting it.
• Show only relevant information, not everything – because un-necessary information clutters the chart.

Today we will learn a dynamic charting technique that will mix these two ideas in a useful way. I call this a Top X chart.

Here is a challenge many people face. How to make a chart visualizing sales data with several dimensions like product, brand, region, sales person name, year (or month or quarter) and one or two values like sales, # of units sold, profits, # of new customers.

In visualization challenge #2, all you have to do is a make a chart or dashboard to visualize this sales data effectively.

It has been a really long time since we have an excel links post here. That doesnt mean I am not reading anything exciting. It is just that I have gotten busy being a dad. But now that I am in to a saner schedule, we are bringing back the excel links. Here is a […]

Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail and chart yourself. I’m having a lot of fun with your gauge template 🙂 To make it more industrial-like, I’ve added: 1. Brushed metal background […]

Yesterday while checking my website analytics reports on Google analytics site, I have noticed a new beta feature called “Intelligence”. Out of curiosity I clicked on it. It took me to a an intelligence alert dashboard. Ok, lets just back up for a minute and understand what “intelligence dashboard” is before moving on. In the […]

Let us say you have built a nice chart showing your sales and profits for the top 5 products (learn how to highlight top 5 products in a list), with products on X axis. Suddenly your boss wants to switch the rows to columns (or transpose the chart) so that she can see metric level grouping instead of product level grouping. No need to freak out and rush to Espresso machine, You can do it very easily with Excel Charting features.

In today’s quick tip you will learn how to swap chart rows and columns in excel.

Yesterday I read about interaction plots on junk charts where he points out the merits of an interaction plot. Interaction plots show interaction effects between 2 factors. For eg. you can show how your product sales have changed between year 1 and year 2 using an interaction plot like the one shown aside.

Check out an implementation of project dashboard along with tweetboard by our reader Fernando. He says, it “turned out to be a great success”. I am so happy for him.

Btw, the post includes a link to download the workbook so that you can see the dashboard and tweetboard in action.

We all know that to make a chart we must specify a range of values as input.

But what if our range is dynamic and keeps on growing or shrinking. You cant edit the chart input data ranges every time you add a row. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?

Well, you can do it very easily using excel formulas and named ranges. It costs just $1 per each change. 😉

Ofcourse not, there are 2 ways to do this. One is to use Excel Tables and another is to use OFFSET formula.

Ever since I was a child, I was fascinated by Paris (and Eiffel Tower). Recently, I had opportunity to visit Paris, albeit for just a few hours (I had a 12 hour lay-over in Paris between flights). I went to see the Eiffel Tower and it looked just as beautiful and majestic as it did in my imaginations.

During my visit to Eiffel tower, I took the stairs to 2nd floor and along the way they have a handful of visualizations explaining the tower. I found them quite interesting and well made. Here, I have listed down 4 simple, yet very effective visualization lessons for all of us.

A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.

We all know that bar charts can be used to display values spread across various categories or times and pie charts / donut charts can be used to display percentage breakup of various quantities in a sum total. How about mashing up both to create a Donut Bar chart?

In this tutorial, you can learn how to make a donut bar chart and linking it to a form control to display Product-wise sales breakups spread across several years.