Creating a scrollable chart is a great trick for enhancing the functionality of your Excel dashboards. You may have years of data to display in the chart, and yet space is limited on your spreadsheet.
By adding a scroll bar to the chart, users can interact with the chart and scroll to see the data they want displayed.
[Read more…] about Create a Scrollable Chart for your Excel Dashboards
Create a Histogram in Excel
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.
[Read more…] about Create a Histogram in Excel
Excel Waterfall Chart that Handles Negative Values
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.
