• Excel Book Excerpt

Excel Comparative Histogram

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

Comparative Histogram

Problem: I want to compare two populations of data.

Strategy: In Excel 2010, use the new left-to-right setting for a data bar.

In the figure below, the data bars on the left use the right-to-left setting.

LE10001151.jpg 

Figure 1119 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

LE10001152.jpg 

Figure 1120 Use Manage Rules, Edit Rules to access this.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy