Using Color Ranges for Easy Management by Exception

One question that all managers ask themselves is: “What are we doing well and what are we not doing well?” As you look at your spreadsheets and reports, it’s sometimes hard to tell at a quick glance where the problem areas are so you can focus your time and efforts on the areas that need it the most. One of the features in iDashboards that helps to solve that problem is our Color Range Sets. So, how do they work?

Let’s take the following map chart as an example:

In this map chart, a sales executive is able to use a simple red, yellow, green color scheme to see which states have revenue below $10,000,000 (in red) and which are above $25,000,000 (in green). As soon as he or she opens the dashboard, the executive can tell that the company is struggling with sales in four states and will be able investigate why.

To create your own color range sets, just right-click on your chart, select chart properties, and find the colors tab. You will see the section called Range Sets:

Here you will able to create as many or as few ranges as you like. You can add colors by clicking on the empty color box near the bottom, selecting your color, then entering the lower number of your range. It’s that simple! You can use these ranges on all kinds of charts, like bar charts, line charts, speedometers, and more. Just keep in mind that for some chart types, such as bar charts, you may have to go to the features tab to enable showing the colors (In that case you have the option to color code the bars or the grid background).

So now that you know how to color code your charts, go try it yourself and see how much easier it can be to visualize your data!

Alex Stark– Technical Consultant, iDashboards

Leave a Reply

Your email address will not be published. Required fields are marked *