Posts Tagged ‘Free Template’

Network relationship chart

Posted: November 6, 2014 by MaxFraudy in Excel
Tags: ,

This is great…

User Friendly

I’m a big fan of anyone who can display data in a visual way.  Well today, rather than displaying my own work or giving a “how to” guide, I thought I’d display work from Chandoo.org – one of the best sites for Excel help.  This network / stakeholder relationship chart is a work of art and needs no explanation from me.  The full tutorial and example template can be found here: http://chandoo.org/wp/2014/08/13/network-relationship-chart/

Hope you find it as inspiring and as useful as I did!

+Alesandra Blakeston

network-relations-chart-demo

View original post

Advertisements

This is a common requirement while creating dashboards. One selects an option and the charts update to show data for that particular selection. It would be very useful if the same chart could show you how that particular selection fares against average or a set benchmark.

Comparison Chart Against AverageLet’s take an example. I have data for a class of students with their subject marks. I make a selection of the student name, his marks for each subject are plotted on a chart. I wish to see how this particular student has performed in each subject as against the class average. This custom chart does just the same, and it can be very very easily created in Excel as below:

(more…)


Although this is not my personal favorite chart, I have seen that many people find it fabulous since it looks good on a dashboard. I think that it takes too much space for the small information that it conveys. But then, that’s just me.

Gauge Chart

Gauge Chart

(more…)


There are numerous Project Management tools available in the market which make life easier while managing huge projects. But for simpler projects, you don’t need all that jazz, just a simple project plan template is all that is required. Well, you can use conditional formatting to create simple Gantt Charts. Here’s how:

Step 1: Create your list of tasks and the decide the proposed dates against them. On the top row, put down the dates (one in each column) like this:

Task List

Task List

(more…)


As you can see from the picture, this chart can be used when you want to compare two entities on same parameters. Here, I’m comparing sales at two stores of some items.

Butterfly Chart

Butterfly Chart

To create the chart, follow these steps: (more…)


A Waterfall Chart is a great way to present data when looking at the incremental contribution of individual elements in reaching from one milestone to the other. Let’s take an example below. The left most column shows the total sales for last year, the right most shows the total sales for current year and the segments in between show the incremental contribution of each region in current year over last year. The reds show a negative contribution and the greens show a positive one.

Waterfall Chart

Now let’s learn how to make this chart. (more…)


Tolerance - RAG ChartEarlier we had seen the Thermometer Chart that lets one see where a value is lying with reference to a scale. That works when you are measuring everything on the same scale and when the maximum is defined (hence a 100% stacked chart). At times, e.g. when comparing Actuals vs Targets, you might just want to see a RAG (Red-Amber-Green) picture. Let’s see this using an example. Let’s say that I have set targets for the four regions and I have Actuals data as below:

Tolerance - Raw Data

Raw Data

(more…)


When we need to compare data points from two time periods side by side, we normally use a column chart with two series (for the two time periods) as below:

YOY Comparison

YOY Comparison

But what if we want to see the comparison of categorised data? I have data for two years, let’s take 2012 & 2013 for simplicity. The data points show the number of employees that were hired in each department. I want to see a month by month comparison of each department, and the total as well. It cannot be done using standard charts in Excel. i.e., we can’t have two (or more) stacked columns side by side like below:

Comparison Stack Chart

Comparison Stack Chart

(more…)


Conditional Formatting is an extremely powerful feature in Excel 2007 and above that can be used not only to beautify spreadsheets but also to highlight things based on some pre-defined rules. Excel provides a lot of built-in rules that mostly work on cell values and are easy to apply. What I’ll be covering in this series is less common applications of conditional formatting. Since it’s a very vast topic (like custom charts), it’s going to be another series.  (more…)


Thermometer Chart

Thermometer Chart

Continuing the series of custom charts in Excel, today I’m sharing the so-called ‘Thermometer Chart’. This chart lets you see sort of ‘how hot you are’ on a scale. This is what it looks like:

Don’t let the looks of this incredible looking chart scare you. It can be created in 7 easy steps using very basic excel charting skills. But if you don’t want to do all the dirty work, just download the ready template Thermometer Chart.

How to Read the Chart?

As in the thermometer, the inner bar is the actual value of the metric that you are measuring and the outer bar is the reference that you are measuring it against.

How to Create the Chart?
  1. Set up the data –  Continue Reading