Excel: Comparative Histogram

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I want to compare two populations of data.

Strategy: Use the left-to-right setting for a data bar. In the figure below, the data bars on the left use the right-to-left setting.

  1. The data bars on the left are positive, but they go right-to-left.

    The right-to-left setting is in the Bar Direction dropdown

  2. Use Manage Rules, Edit Rules to access this.

For more resources for Microsoft Excel