Speedometer with time series (Excel chart shop x2503)


Speedometer with time series If I had to get rid of a chart forever, I would probably choose the speedometer. It is a metaphor taken too far, a waste of premium screen real estate, and it tells you very little. That said, too many people like it and changing their minds [...]

Silhouette area graph (Excel chart shop x6002)


Silhouette graph Depending on your data, silhouette graphs can be very effective and aesthetically pleasing. A silhouette graph usually displays the profile of change over time. This example uses an area chart, but other chart types can be used. (30-day, no questions asked, full money-back guarantee. Pay securely with your Paypal [...]

Cycleplot with bars(Excel chart shop x6003)


A cycleplot with bars I love cycle plots. When is comes to displaying change over time they are much better than a standard line chart when there is a strong seasonality. The other version of a cycle plot available in the Excel Charts Shop is the standard one. The seasonality becomes [...]

Dotplot comparing two series (Excel chart shop x3031)


Dotplot comparing two periods Dotplots are nice alternatives to bar charts: they are much lighter and in many cases detecting a pattern is easier because the chart is much less cluttered. A frequent issue with dot plots is that, when comparing two periods, growth and decline are not obvious. The reader [...]

Scatterplot with marginal distributions and quadrants (Excel chart shop x5008)


Scatterplot with marginal distributions and quadrants Scatterplots can be used for making a vast library of chart types. They can even be used to make scatterplots! (self-deprecating humor: I almost forget the standard scatterplot) This chart shows how to setup criteria to split a series in two, it displays their marginal [...]

Single-chart cycle plot (Excel chart shop x6001)

, ,

Single-chart cycle plot I love cycle plots. When is comes to displaying change over time they are much better than a standard line chart when there is a strong seasonality. The problem with cycle plots in Excel is that they almost require multiple charts, one for each panel. I complain about [...]

Pictorial bar chart (Excel chart shop x3041)


Pictorial graph Pictorial graphs are fun, so it means they are very ineffective and should never be used for serious data visualization. Let's leave this disclaimer, just in case. Now, I can think of many cases where you could use use a chart like this (many include kids, but not all). [...]

Square four-fold chart (Excel chart shop x1011)


Square four-fold chart Four-fold charts are interesting to represent a 2 x 2 table. Weight loss for people following diet A vs diet B and exercise vs  no exercise is a common example of when to use four-fold charts. They can be square or round. If you can't find the round one [...]

Hemisphere pictorial graph (Excel chart shop x1007)


Hemisphere pictorial graph Hemisphere pictorial graph are a standard way of representing the number of members of parliament/congress where each dot represents a single person. Consider a four-party parliament with 600 seats. You can use a doughnut chart to display the four data points, or you can represent the 600 seats [...]

Pie chart with cumulative ring (Excel chart shop x1004)


Pie chart with ring of cumulative values Pie charts should be used wisely (=almost never) but from time to time they can be useful, especially if we take advantage of its best feature: an easy way to display cumulative values. Adding a ring displaying the cumulative value is a way of [...]