Elsewhere in this blog I’ve showed how to Plot Two Time Series With Different Dates:

In Category Axis Tricks for Line and Area Charts – 1 I extended this technique to show how to format parts of a line chart in distinct colors:

A reader asked how to show two years of data on two separate lines [...]

I’ve written several tutorials about creating box and whisker charts, including Horizontal Box Plots and Vertical Box Plots. I’ve also created a professional Box Plot Utility that generates box and whisker charts from raw observations. These techniques are complicated, since they are built using bar or column charts, with extra sets of series to accommodate [...]

An Excel user asked how to produce pie charts of different sizes, so that the total of the wedges comprising each pie dictates its size. The idea behind the different sized pies is to provide a qualitative display of the whole pies and the individual wedges.
I pointed out the generally poor ability to judge areas, [...]

One of the resources I use on my web site is SiteMeter, which has basic (free) and more extensive premium versions of their web site statistics service. I am not endorsing SiteMeter here, just describing their statistics. Sitemeter provides web site tracking by hour of the day. This is pretty granular, compared to daily or [...]

In Clustered-Stacked Column Charts I showed how to create a chart that combined clustered columns with stacked columns. It’s basically just a trick using staggered data to make a stacked column chart so that series display columns for only certain categories, and the gaps give the appearance of clusters of stacked columns. Smoke and mirrors, [...]

I wrote in Stock Chart with Added Series how to add extra series to an Excel candlestick stock chart. The procedure was written while using Excel 97, and it has worked well until Excel 2007 forced some small changes to the protocol. The tutorial in that article was long and tedious, and could probably be [...]

Chandoo wrote a tutorial about Sales Funnel Charts in Excel. Technically his protocol was okay, and the result looks, well, like a funnel. I’ve written about Funnel Charts (Bad Graphics) and Stacked Pyramid Charts (Bad Graphics) before, and Chandoo’s doesn’t suffer from a misuse of 3D and shading effects.

The problem with Funnel and Pyramid charts [...]

In the Engineering Windows 7 blog on MSDN, in Windows 7 Energy Efficiency, The Windows team posted a chart showing how energy is consumed in a modern laptop.

No surprise that almost half is spent lighting the display.
But wait, that looks a lot closer to 50% than 43%. Let me see what I get using their [...]

Chance Magazine is holding a data visualization contest. The objective is to produce a clear, insightful, succinct, original, and aesthetically appealing display of a set of comparative data on antibiotic effectiveness. The data is shown below: click on the picture of the data to download a CSV file if you want to play along at [...]

In the microsoft.public.excel.misc news group, Flojoe presented a set of data and asked how to present it to show the outstanding growth in revenue over the past few years. I put together a panel chart with stacked columns to compare growth over the prior year’s revenues.
Flojoe’s original data is shown in bold text in the [...]