Category Archives: Dashboard Design

Motion Chart in Excel

Posted on November 20, 2009 by kriteeka | 12 comments | Category | Tags

- Contributed by Kamesh M We all know that using a Bubble Graph one can show three different dimensions of data i.e, X-axis, Y-axis and the Size of the Bubble to represent an additional dimension of information for the given …

Read More →

Chart Axis Labels – Conditional Formatting

Posted on April 27, 2009 by kriteeka | 6 comments | Category | Tags

- Contributed by Gunjan Aggarwal We all like conditional formatting for the fact that data can be better projected that way. It makes data easy to read and conclude. It can be used in creating the Interactive dashboard, Routine reports, …

Read More →

Reason out the Hike or the downfall of the trend in a better manner: Another Dashboard Tip

Posted on March 14, 2009 by kriteeka | 1 comment | Category | Tags

- Contributed by Gunjan Aggarwal In earlier blogs, we learn how to create interactive charts with the help of checkboxes. Those who have missed that blog post can read the article on using check boxes for a neat treat . …

Read More →

Representing graphs more meaningfully: A Dashboard Trick

Posted on March 9, 2009 by kriteeka | 5 comments | Category | Tags

 - Contributed by Gunjan Aggarwal A layman who would look at the above graph, at his first glance would tell that the Paid Search had not performed well in the initial months, or HE/SHE would think that there must be …

Read More →

Count that word in the cell

Posted on February 27, 2009 by kriteeka | 0 comments | Category | Tags

- Contributed by Deep Moni Hazarika Counting the length of a string or characters is easily done in excel. Just the LEN() function and simple. But the one day I was asked if there was any way to count a …

Read More →

Using Combo Box for a Neat Dashboard Treat!

Posted on December 17, 2008 by kriteeka | 92 comments | Category | Tags

- contributed by Gunjan Aggarwal We have already learnt how to create an interactive chart using Check Boxes in our last blog. The check box allows the user to view different sources of data in a better manner. But it’s …

Read More →

Dashboard Design Tricks [Part 1]: Using Checkboxes for a neat treat

Posted on December 6, 2008 by kriteeka | 17 comments | Category | Tags

- contributed by Gunjan Aggarwal Dashboard designs are one of today’s most discussed topics. The first dashboard created for a client is always a challenge. Limited time and best results. One of the things that can be done to simplify …

Read More →