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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920