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. Charts and Graphs: Microsoft Excel 2010
For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. Microsoft Excel 2010 In Depth by Bill Jelen
For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions. MrExcel
...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. Charts and Graphs: Microsoft Excel 2010
For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. Microsoft Excel 2010 In Depth by Bill Jelen
For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions. MrExcel
Transcript of the video:
MrExcel podcast is sposored Easy-XL.
Learn excel from MrExcel podcast.
Episode # 1523 - Comparative Histogram 2 Hey in yesterday's podcast, episode # 1522 JB had asked how to create a comparative histogram.
I showed how to do with a chart, but you know there's a couple of other tools.
Let's just go incredibly old school here =REPT The repeat function repeats text a given number of times.
I want to repeat the vertical bar character, and we will say that I want to repeat it lets say 90/3 You kind of have to scale this. Like if I had 90 vertical bars, it would be really wide it wouldn't fit on a piece of paper, so divided by 3, and you see you kind of get that that same effect. Right now it's copied over here for the males to make this look better though.
We'll take the change of the font for the males to red .
We'll also go right justified for the males shift + enter and there I'll press F4 to repeat and then here we will change the color.
So Home and use one of the blues all right, so you kind of get that comparative histogram look.
Certainly not as fancy as the chart but we get the labels where we want them and that would work.
If you happen to be in excel 2010 2010 then you could use in this method.
Now we'll take the females.
Home Styles Conditional Formatting Data Bars and I'm going to choose the solid blue data bar for females and over here, Home Conditional Formatting Data Bars I'll choose a solid red for the males. Okay now. You could have done this in Excel 2007.
It's this next step that only became available starting in excel 2010, when I come down here to Manage Rules and I'm going to edit that rule and they've added a great setting of Bar Direction and I can say that I want it to go Right - Left. Right to left.
Show Bar Only Click OK Click OK and then come over here and Manage Rules again Edit and Show Bar Only. That time I'll let it go left to right.
Click OK Click OK So there you have a comparative histogram excel 2010 only or newer.
Using the Conditional Formatting Data Bars.
For more great ideas about charts and graphs and data visualization, check out my book Charts and Graphs Microsoft Excel 2010 from the MrExcel library.
Well hey I want to thank you for stopping by.
Will see next time for another netcast from MrExcel.
Learn excel from MrExcel podcast.
Episode # 1523 - Comparative Histogram 2 Hey in yesterday's podcast, episode # 1522 JB had asked how to create a comparative histogram.
I showed how to do with a chart, but you know there's a couple of other tools.
Let's just go incredibly old school here =REPT The repeat function repeats text a given number of times.
I want to repeat the vertical bar character, and we will say that I want to repeat it lets say 90/3 You kind of have to scale this. Like if I had 90 vertical bars, it would be really wide it wouldn't fit on a piece of paper, so divided by 3, and you see you kind of get that that same effect. Right now it's copied over here for the males to make this look better though.
We'll take the change of the font for the males to red .
We'll also go right justified for the males shift + enter and there I'll press F4 to repeat and then here we will change the color.
So Home and use one of the blues all right, so you kind of get that comparative histogram look.
Certainly not as fancy as the chart but we get the labels where we want them and that would work.
If you happen to be in excel 2010 2010 then you could use in this method.
Now we'll take the females.
Home Styles Conditional Formatting Data Bars and I'm going to choose the solid blue data bar for females and over here, Home Conditional Formatting Data Bars I'll choose a solid red for the males. Okay now. You could have done this in Excel 2007.
It's this next step that only became available starting in excel 2010, when I come down here to Manage Rules and I'm going to edit that rule and they've added a great setting of Bar Direction and I can say that I want it to go Right - Left. Right to left.
Show Bar Only Click OK Click OK and then come over here and Manage Rules again Edit and Show Bar Only. That time I'll let it go left to right.
Click OK Click OK So there you have a comparative histogram excel 2010 only or newer.
Using the Conditional Formatting Data Bars.
For more great ideas about charts and graphs and data visualization, check out my book Charts and Graphs Microsoft Excel 2010 from the MrExcel library.
Well hey I want to thank you for stopping by.
Will see next time for another netcast from MrExcel.
