Excel - Comparative Histogram Part II: Episode 1523

1,893 views · Published 29 February 2012 · 2:56 · Indexed 23 October 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: A second method for a comparative histogram chart.

Welcome to another episode of the MrExcel podcast. In today's episode, #1523, we will continue our discussion on comparative histograms. In yesterday's episode, #1522, JB had asked how to create a comparative histogram and I showed how to do it with a chart. But did you know there are a couple of other tools you can use? Let's go old school and use the =REPT function to create a comparative histogram.

The =REPT function allows you to repeat text a given number of times. In this case, we will repeat the vertical bar character to create our histogram. We will scale it by dividing the number of bars we want by 3, so it fits on a piece of paper. Then, we can change the font and color to differentiate between the male and female data. This method may not be as fancy as using a chart, but it gets the job done and allows us to have control over the labels.

If you are using Excel 2010 or newer, there is another method you can use. Instead of using the =REPT function, we can use Conditional Formatting Data Bars. This allows us to create solid blue data bars for females and solid red data bars for males. But the real magic happens when we edit the rules and change the bar direction to go from right to left for females and left to right for males. This creates a comparative histogram that is only available in Excel 2010 or newer.

For more great ideas on charts, graphs, and data visualization, be sure to check out my book "Charts and Graphs Microsoft Excel 2010" from the MrExcel library. Thank you for tuning in to today's episode and be sure to join us next time for another netcast from MrExcel. Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Comparative Histogram 2 
(00:12) Using the =REPT function 
(00:22) Scaling the vertical bars 
(00:32) Formatting for males 
(00:51) Formatting for females 
(01:51) Method for Excel 2010 
(02:35) Clicking Like really helps the algorithm

This video answers these common search terms:
Bar direction in conditional formatting
Charts and graphs in Excel 2010
Comparative histogram
Conditional formatting for data bars
Creating a comparative histogram in Excel 2010 or newer
Creating vertical bars in Excel
Data visualization in Excel
Formatting vertical bars for males
Learn Excel from MrExcel podcast
MrExcel podcast
Repeat function in Excel

In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill shows us alternative ways to set up a visual Comparative Histogram without using a Chart, thus giving us more options to represent our data. 

...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. http://www.mrexcel.com/store/index.php?l=product_detail&p=183 

For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. http://www.mrexcel.com/store/index.php?l=product_detail&p=189 

For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions. http://www.mrexcel.com

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153201/

More from this channel