This Excel PivotChart shows a YOY comparison of invoices for three years. These comparisons can be fairly easy or very complex depending on the how the business stores its data.

How to Make Your Data Pop with Custom Excel Stencils for Comparison Charts 8:45 am May 13, 2025 By Julian Horsey Have you ever stared at a bland spreadsheet, wondering how to make your data truly ...

Using Excel 2013's Frequency function as an array quickly compiles the frequency data from a list of "bin" ranges. You can then display this data on a bar chart to more readily compare the ...

As you’re working on your own pivot tables, you can experiment to see how added and removing fields affects the data that’s displayed. You’ll find that Excel does a great job of making ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you ...

You’ll now have an Excel bar chart that lists your tasks and dates—in reverse order. (Don’t worry; we’ll fix that in a minute.) Step 5: Transform Into a Gantt Chart ...