Excel - Old School Data Bars Using the REPT Formula in Excel - Dueling Excel - Episode 1369

1,826 views · Published 25 March 2011 · 3:19 · Indexed 16 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Using REPT function to create a bar chart in a cell in Excel. 

Welcome to another exciting episode of Dueling Excel! In this podcast, Bill Jelen from MrExcel and Mike Girvin from Excel is Fun are live at Highline Community College in scenic Des Moines, Washington. That's right, Washington! Did you know there's a Des Moines in Washington? Well, now you do! Join us as we explore the world of data bars and how they can make your data come to life.

Data bars are like turning a histogram on its side, giving you a visual representation of your data. In this episode, Mike will show you how to use conditional formatting to create data bars, making it look like a cell chart. He'll also teach you a handy trick to quickly copy the formatting to other cells. And if you have Excel 2007 or newer, you'll get to see the cool gradient data bars that are available.

But what if you don't have Excel 2007? Don't worry, Bill has a solution for you. He'll show you how to use the REPT function to create data bars. This function allows you to repeat a character or number a certain number of times, making it perfect for creating data bars. And if you're feeling adventurous, you can even use different characters, like asterisks or wingdings, to customize your data bars.

So whether you're a fan of the newer data bars or prefer the classic REPT function, this episode has something for everyone. Join us as we have fun exploring the world of data bars and making our data more visually appealing. And don't forget to tune in next week for another exciting episode of Dueling Excel. Thanks for watching!

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) Creating Data Bars
(01:24) Using REPT function
(02:07) Scaling the REPT function
(02:26) Alternative options
(03:05) 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:
Cell chart in Excel
Conditional formatting
Excel 2007 features
Excel 97 features
Excel data bars
Gradient data bars in Excel
Histogram in Excel
Plain bars in Excel
REPT function in Excel
Solid fill in Excel
Using wingdings in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153048/

Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.

More from this channel