Join Dennis Taylor for an in-depth discussion in this video Using the REPT function to represent data visually, part of Excel Tips Weekly.
- View Offline
- You can represent numerical information visually,…by way of a chart, or perhaps by way of sparklines.…You can also do this by way of a text entry,…using a function called R-E-P-T.…Think of the word "repeat."…Let's say that to accompany the data in column D,…we might want a visual to the right…that gives us the relative size of these salaries.…Equal R-E-P-T, repeat, we begin…with the symbol or symbols we want to repeat.…Within double quotes, I'm gonna use capital X.…
I wanna have this repeated.…Now, I don't wanna have it repeated 30,000 times,…but I might wanna take the entry in column D…and divide it by 10,000, so I refer to column D,…cell D2 here, divided by 10,000.…So, we're about to see three Xs here…as I double-click to copy this down the column,…four Xs there, three, two, and of course…this corresponds with the salary.…Notice how it simply drops;…we're not doing any kind of rounding…or anything like that.…So, this gives us a relative visual here.…In some cases, you might want to hide column D.…
Maybe copy the word "salary" over here,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.