When using column charts to compare values, you may want to highlight the maximum and minimum values on the chart. By highlighting these columns it removes any confusion when trying to view the top and bottom values.
Finding the Max and Min Values
To show the max and min values on a column chart, we will first need to identify the max and min values of our range. These values will then be used as a second data series when we create the column chart.Continue reading →
A Histogram is used in statistics to graphically represent the distribution of data. It looks like a column chart with each column representing an interval (bin), and the column height representing the frequency that it appears.
Essentially the graph groups numbers into intervals (bins) and displays how often they appear. The graph then beautifully illustrates how the sets of numbers are distributed.
The main problem people come across when working with Waterfall charts in Excel is that they cannot handle negative values. When a negative value is entered it appears below zero destroying your clever Waterfall chart.
Now there are a few utilities on the market that can help you create a Waterfall chart in a snap. But you don’t need these if you know how to work with them.
This tutorial comes from a video I watched of Bill Jelen explaining how to create Waterfall charts. This video can be seen below.
This is the best Waterfall chart tutorial I have seen. I found it easy to follow, very useful, and therefore wanted to share it with you guys.
The image below show the layout of the Waterfall chart data with the formulas shown so that you can see how it all works.