Excel - Create In-Cell Bar Chart Using REPT function - Episode 1211.409

Microsoft Excel Tutorial: Create in-cell bar chart using REPT function. Welcome back to MrExcel! In this episode, we're going to dive into Excel Charts Chapter 9 and learn how to create a chart without actually using a chart. That's right, we're going old school with the REPT function. You may be familiar with the Data Bar concept introduced in Excel 2007, but we're going to take it a step further and create a visual representation of our data using the REPT function. This function repeats a certain text a specified number of times, and we're going to use it to create a bar chart. To start, we'll use the pipe character (|) and the number we want to repeat, in this case 56. Copy that formula down and voila, we have a simple bar chart! This works well for smaller numbers, but what if we have larger numbers? In that case, we can use the REPT function in combination with the division operator to scale down the numbers and create the correct size bar chart. But why stop there? You can also get creative with different fonts, such as Webdings or Wingdings, to create thicker bars and give your chart a unique look. The possibilities are endless with this simple yet powerful function. So there you have it, a chart without using a chart. Thanks for tuning in and be sure to join us next time for more Excel tips and tricks. Don't forget to check out our sponsor, Excel-XL, for all your Excel needs. See you next time on MrExcel! 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-... Table of Contents: (00:00) Creating a Chart Using REPT function (00:43) Creating a Bar Chart (00:53) Adjusting for Larger Numbers (01:26) Playing with Different Options (01:41) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Creating a bar chart with the REPT function Creating a chart without using a chart Creating a solid bar effect Creating a visualization with formulas Data Bar concept in Excel 2007 Excel Charts Chapter 9 Excel-XL sponsorship Next netcast from MrExcel Scaling down bar charts with larger numbers Thanks for stopping by Using different fonts for thicker bars Using the REPT function Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads... Replace a bar chart with in-cell formulas