A popular graphical technique divides the plotting area of a chart into four quadrants, to facilitate such analyses as risk-reward. For example, one axis shows risk and the other shows reward; the quadrants divide risk and reward into low and high regions, and the quadrants show the combinations (low risk-high reward, low risk-low reward, etc.). [...]

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 [...]

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 [...]

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 [...]

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 [...]