 Hello everyone, welcome back to another video. So this video is probably going to be shorter than normal But I saw this great tip online and thought it'd be worth sharing with you in case you have some use for it So in this scenario a very basic two column table here We've got a list of results and simply here I want a visual or a visual way of Representing obviously the size difference between all these numbers. So I'm going to create a bar chart or a single bar for each One so in order to do that all we simply need to do here is go Equals RPT. So as in short for repeat open brackets for this example I'm going to use the vertical line. So to do that I want to do the quotations holding down a shift the vertical line depending on where is on your keyboard and the quotation there go comma and then how many times do I want to repeat this number? So for me, I want to do it 60 Well, I don't want to just do it 60. I want to select obviously this cell which contains my first value Hit enter and you can see obviously it's now given me 60 Repetitions of that simple are provided if I was to put something like a P in here But the letter P you can see it's going to give me 60 of them But for this example as will become clear in a minute We're going to be using the vertical line if I simply copy that down you can see how it's replicated for all of those other rows and We can see because it's going to repeat it a number of times We've got the actual true scale comparison between each of these columns Not even a column. Sorry each of the rows So what I'm going to do next is literally highlight these rows in question Obviously depending if your range is larger and we're going to go up here and in our font selection We're going to type the word play and you'll see we get the option of play bill Simply all I'm going to do is hit enter and you can see we've now got this great bar For each of those rows So you could stop here if that's as far as you want to go to Although I'm going to take it one step further and add some conditional formatting to really get a good Difference or differentiate between these rows. I'm going to simply copy or note highlight all that range and by default I want to change the font color to orange So let's go into our drop down here and select orange and then so we can see by default of the orange So let's just re-select this range and this time go into conditional formatting and go into create a new new role a new rule Sorry if I get the words out and the option I want here is use a formula to determine which cells to format and simply all I'm going to do here is go equals length So this is going to be counting the length or the number of characters available in a cell But the first one to do is select the first cell in my range, which for me is going to be C5 Close brackets and the rule for this one is if it's 75 or greater So what I'm going to do is if it's greater than 74 so obviously 75 and above I want to change the Font color to a green. So once that opens up, we can see we're in the font tab Let's go down and select a nice green or don't know if I've got any nice Well, they go that there's a green we get the idea here and we'll select okay here and we'll go okay again So what you can see what's happened there now is any value 75 and greater we can see it's now changed to green So what I'm going to do is select our range once again conditional formatting new rule Use a formula to determine which cells to format and then in here will do equals LEN open brackets And we'll again go C5. That's the first one in my range close brackets. So this time we want anything that is less than 25 If it's less than 25, I want to change the font color to red. So we go get a red there Click okay. Click. Okay. Once again, and you can see only one of the values is obviously Falling into that criteria. So let's say we change this 65 to maybe 15 Enter you can see it's now gonna not only change the size of that bar But it's also going to change it to red because it's less than our criteria of 25 again sticking the same one Let's just try and make this one 50. You can see it's going to orange. Let's make it to a number 75 or above so they're 95 and you can now see we've got the green So it's a really dynamic solution and it's a great way to take a very simple Single column of data and represent that visually via a bar chart So I hope you found that video useful and whether you have some use for it now or maybe have it in the future Hopefully this will be a good tip that you can use in your Excel files If you did enjoy that video, please don't forget to like the video and also subscribe to the channel So you're notified as soon as you bring out any future videos And if you do have any questions about this video, just drop me a comment below and I'll get back to you As soon as I can so thanks again for watching and we'll see you in the next video