New Member
Advanced Excel Formulas
November 8, 2012
New Member
Excel for Decision Making
June 24, 2016
Alan Winegar said
What is the difference between using REPT function and using the bar chart, and why would you use the REPT function over the bar chart.
I recently used the REPT function in my table that I was created for a report. The bar chart would be external to the table. The bar chart and the REPT function both are great ways to present the data. REPT function I would use if single chart is needed, Bar Chart would be nice in a dashboard.
Tony
Active Member
June 24, 2016
I think of the REPT function as being similar to the sparklines feature. It just depends on what visualization is appropriate for your project. Is it more appropriate to show your data purely with a visual? If so then a dedicated chart might make more sense. Or do you just want to throw in a visual on the side to give your numbers a little more pop, and make any outliers stand out more? If so then a REPT function might be better.
New Member
June 24, 2016
Just adding to what JoAnn says - It is comparatively little quick & is used for small bite-sized data visualization. Should you wish go through some different In-Cell charts, you may follow the below link
1 Guest(s)