Create a visual representation of your values without using a Chart. In Episode #1309, Bill shows us how to use the "Pipe" Character ( | ) with the 'REPT' Function to show the variances in a data set - even when the values are very large.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel Charts, chapter 9.
Repeat Charts.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
This is how to create a chart without using a chart at all.
Right now, I know that Excel 2007 introduced the data bar concept.
We're going to go really old school here.
I want to create a nice visualization of these numbers.
Here's what I'm to do I'm going to use equal REPT.
This function repeats certain text, a certain number of times.
Alright! So, I'm going to use the pipe character, the pipe is that thin Little vertical bar.
And how many times I want to repeat it?
Well, I want to repeat it the number, so 56 in this case.
Copy that down and what we get is a nice little bar chart that is appearing right there in those cells.
So, now we have a cool bar chart.
Now, this works out because my numbers are, you know small if I had larger numbers here, let's change these to be just do equal, RAND Between.
Perhaps, 200 and 1000.
So, now we're going to have really, really big numbers.
It's not going to work out so well, so then in that case you'll want to use this function, but that you do B2 and divided by something.
So, divided by maybe a 50.
They're kind of scale things down and then that will create the correct size bar charts.
You can also play with different things, I've seen Mike Alexander.
You know, find it a nice font in Webdings or Wingdings, that kind of provides, you know, a thicker bar.
It actually makes it look like a solid bar.
So, go through various items there, so.
You know this is when we don't even have a chart, we just simply use a formula to...
Hey! I want to thank you for stopping by, see you next time for another netcast from MrExcel.
Excel Charts, chapter 9.
Repeat Charts.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
This is how to create a chart without using a chart at all.
Right now, I know that Excel 2007 introduced the data bar concept.
We're going to go really old school here.
I want to create a nice visualization of these numbers.
Here's what I'm to do I'm going to use equal REPT.
This function repeats certain text, a certain number of times.
Alright! So, I'm going to use the pipe character, the pipe is that thin Little vertical bar.
And how many times I want to repeat it?
Well, I want to repeat it the number, so 56 in this case.
Copy that down and what we get is a nice little bar chart that is appearing right there in those cells.
So, now we have a cool bar chart.
Now, this works out because my numbers are, you know small if I had larger numbers here, let's change these to be just do equal, RAND Between.
Perhaps, 200 and 1000.
So, now we're going to have really, really big numbers.
It's not going to work out so well, so then in that case you'll want to use this function, but that you do B2 and divided by something.
So, divided by maybe a 50.
They're kind of scale things down and then that will create the correct size bar charts.
You can also play with different things, I've seen Mike Alexander.
You know, find it a nice font in Webdings or Wingdings, that kind of provides, you know, a thicker bar.
It actually makes it look like a solid bar.
So, go through various items there, so.
You know this is when we don't even have a chart, we just simply use a formula to...
Hey! I want to thank you for stopping by, see you next time for another netcast from MrExcel.
