Create an Excel Chart with REPT, TEXT and SUM

Video • 6 minutes

‍

Learning Objectives

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.

‍

Lesson Description

‍

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.

Turn on the To-Do Bar in Outlook