When you have two series in a chart, and you want to show them using two different chart types, you have a broad array of choices. If you have target and actual data for a set of product attributes, for example, you can make a column-line combination chart readily.
Suppose your data looks like this (ignore [...]

Today’s post is written by David Montgomery, who has a new blog called David @ Work. David read two of my recent posts, Fill Below an XY Chart Series (XY-Area Combo Chart) and Fill Between XY Chart Series (XY-Area Combo Chart), and noted the lack of an explanation for different colors between XY series that [...]

In Fill Below an XY Chart Series (XY-Area Combo Chart) I introduced a technique for filling the area below an XY chart. This article shows how to extend that technique to filling between two XY series.

The trick is to use a chart that combines XY and Area type series. I described this technique in XY [...]

How can you fill the area below an XY series in an Excel chart? You can’t just use an area chart for this, because the X axis won’t work out right, and an Area chart does not provide markers, only border and fill.

The trick is to use a chart that combines XY and Area type [...]

In Challenge – Show Market Share Changes I suggested a panel chart in response to Chandoo’s Visualization Challenge – How to show market share changes? In Explore Your Data With Pivot Tables I showed how a simple pivot table analysis could lead to this type of chart. And in this post I will show the [...]

This tutorial shows how to create Clustered-Stacked Charts, including the specialized data layout needed, and the detailed combination of chart series and chart types required. This manual process takes time, can be prone to error, and becomes tedious.
I have created the Peltier Tech Cluster Stack Chart Utility to create such charts automatically from raw data. [...]

One of my most popular blog posts of all times is Clustered-Stacked Column Charts. This post has received the most visits and is the most heavily commented post I’ve written. One reader wants to know how to add vertical lines between the clusters. This is an adaptation of the technique in Add a Vertical Line [...]

In Plot your data around the clock, Chandoo proposed a complicated bubble chart to show website traffic vs. time of day.

I thought it was daring of Chandoo to try such a unique treatment of the data, but I found the bubbles difficult to interpret, and it was distracting that I had to look from chart [...]

Excel offers clustered column charts and stacked column charts among its standard options.

A common request is for a clustered-stacked column chart where the columns are clustered together, while one or more of the clustered columns are divided into sections stacked on top of each other. This isn’t built into Excel, but by rearranging the worksheet [...]

In yesterday’s post, Add a Target Line, I showed how to add a simple horizontal line target indicator to a chart. What if your target isn’t constant. I’m not talking about your boss’ moving target, but a case illustrated by the following dummy data. Our company makes widgets, which are more popular in spring and [...]