Using REPT to Make Microcharts in Excel

While Excel 2013 and 2016 have sparklines for microcharts, they don't always do what you want, like make horizontal bar charts (you can do column, line charts, and win-lose graphs however).  And older versions of Excel don't have sparklines.

You can atone for that to an extent by using the REPT function as explained in this article at Chandoo's Excel Blog.  Chandoo is an Excel authority and does a great job of showing what REPT can do for you.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.