How to make stream graphs in Excel?
A stream graph or stream plot is an area chart that looks like a stream. In this post, let me show you how to create an interactive stream graph using Excel area charts. The original design for this graph is inspired from Cedric Scherer.
How to show positive / negative colors in area charts? [Quick tip]
Ever wanted to make an area chart with up down colors, something like this? Then this tip is for you.
Source vs. Use of Funds – 14 charting alternatives
Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source vs. uses of funds? In this post, let’s review 14 charting options. Source vs. Use of funds – Sample Data for this problem Let’s say […]
Joyplot in Excel
Over on Twitter, I came across this beautiful chart, aptly titled – Joyplot. It is the kind of chart that makes you all curious and awed. So I did what any Excel nerd would do. Recreated it in Excel of course. This post takes you thru the process.
Take a look at final outcome above. Read on to learn more.
Color changing line chart [tutorial]
Let’s learn how to create a color changing line chart using Excel. This is what we will create.
Looks interesting? Read on.
Shading an area chart with different colors for up & down movements [case study]
We all know that area charts are great for understanding how a list of values have changed over time. Today, let’s learn how to create an area chart that shows different colors for upward & downward movements.
The inspiration for this came from a recent chart published in Wall Street Journal about Chinese stock markets.
We will try to create a similar chart using Excel. We are going to create the above chart in Excel.
Looks interesting? Read on…
Did Jeff just chart?
How do you segment customers by revenue easily in Excel, so that you can see which customer groups to focus on. Find out, and download this handy template.
In this charting example, Jeff, our guest author, occasional charter and Excel wizard shows us how to segment customers based on revenue and depict the result using Excel charts.