This course can be purchased as part of the
Personal Development
bundle. Enquire here!
Personal Development

Create an Excel Chart with REPT, TEXT and SUM

This course is in the base subscription pack
Category
Personal Development
Bundle - Sub Category
Course Duration
0:05
Subject Matter Expert
Deb Ashby
Provider
Assemble You

Discover how to create a unique and visually exciting chart in Excel using the combo of REPT, TEXT and SUM functions. We'll show you through building a formula-driven chart without using traditional chart tools. Perfect for adding some flair to your spreadsheets while reinforcing core Excel skills.

Target Audience

Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.

Learning Outcomes

Learn to use the REPT function to repeat characters dynamically.

Combine REPT, TEXT and SUM to build custom formula-based charts.

Understand how to visualise data proportions using basic Excel functions.