Create a visual representation of your values without using a Chart. In Episode #1309, Bill shows us how to use the “Pipe” Character ( | ) with the ‘REPT’ Function to show the variances in a data set – even when the values are very large.
From Chapter 9…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.