Join Dennis Taylor for an in-depth discussion in this video Use symbols and the REPT function for in-cell charts, part of Excel: Charts in Depth.
- [Instructor] In Excel there's a function called REPT, … think of the word repeat. … Obviously it's spelled differently. … This worksheet has that name in it. … It's for an in cell chart. … This is a variation on a chart that actually can use a … symbol and tons of symbols are available too. … Let's imagine that although we see … column D here with salaries, … we've got 600 entries here, let's say we don't really … want to show the salaries, we might want to show a series … of symbols, maybe asterisks, or some other symbols, … that just give us the relative size here. … And typically we'd do this in a separate column, … and we might or might not want to keep column D visible. … I'm going to zoom in, holding down the Control key, … rolling the mouse wheel, … and, first of all, just put the letter X up here in cell E1. … That'll be our starting symbol. … Doesn't have to be capitalized, it can be any letter, … or eventually symbol that we want. … The function, REPT, … allows us to select certain text, …
Author
Released
9/26/2019- Chart essentials
- Fine-tuning charts with design tab choices
- Inserting pictures, shapes, and text boxes
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Changing a chart's data source
- Printing and sharing charts
- In-cell chart alternatives
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: Advanced Formulas and Functions
with Dennis Taylor4h 35m Intermediate
-
Introduction
-
1. Chart Essentials
-
Overview of chart types3m 11s
-
Choose styles and layouts3m 42s
-
Change chart orientation3m 26s
-
2. Fine-Tune Your Charts
-
Add a chart element2m 31s
-
-
3. Adjust Chart Elements
-
Modify axes3m 22s
-
Link titles to content2m 59s
-
Add and edit data labels3m 28s
-
Add a data table3m 9s
-
Work with gridlines3m 19s
-
Use legends3m 22s
-
-
4. Format Tab Options
-
Work with shapes and arrows2m 56s
-
Add shape styles and effects3m 31s
-
Work with chart text2m 53s
-
Apply WordArt styles2m 5s
-
5. Work with Popular Chart Types
-
Column and bar charts3m 16s
-
Line and area charts3m 25s
-
-
6. Other Specialized Excel Charts
-
Combination charts3m 23s
-
Stock charts3m 30s
-
Scatter charts3m 30s
-
Bubble charts3m 27s
-
Radar charts3m 26s
-
Gantt charts3m 31s
-
-
7. New Excel Chart Types
-
Overview of new chart types2m 23s
-
TreeMap charts3m 24s
-
Sunburst charts1m 51s
-
Histogram chart3m 18s
-
Box and whisker chart3m 30s
-
Pareto chart2m 21s
-
Waterfall and funnel charts4m 19s
-
-
8. Change a Chart's Data Source
-
9. Print and Share Charts
-
Print charts3m 48s
-
-
10. In-Cell Chart Alternatives
-
Conclusion
-
Next steps25s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Use symbols and the REPT function for in-cell charts