Using Data Table, or Better Bar Chart

Excel Dashboards by ExcelUser.com - Instructional eBook and Ready-to-Use Workbooks.

I've prepared this page as part of my response to the Using Data Tables blog entry in Kaiser's fine Junk Charts blog.

Kaiser contends that sometimes a table is better than a chart. The example given in his blog entry does in fact demonstrate that a table is better than the chart that was used, but a better chart can overcome his objections. In the first chart below, the decoupling of the two separate charts in the example is overcome by creating a single clustered bar chart with separate axes. In Excel this is a challenge because secondary series are usually plotted in from of the primary series. This is overcome using two dummy series to offset the real series to either side of the category, as described in Column Charts on Two Axes elsewhere on my web site. The relative values of each series can readily be compared within and between categories.

To provide actual numbers, one can easily add data labels to the chart's data points, and incorporate totals into the axis titles, as shown below.

I've posted a zipped workbook with my charts here: ClusterBarTwoAxes.zip.

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile