Image: 200degrees/Adobe Stock. Area charts do a great job of exposing trends in Microsoft Excel data. The good news is that they’re easy to create; the bad news is that the default chart is ...

In Excel, it is straightforward to insert a Gantt chart or a Dynamic chart. However, the problem starts when you include more cells or columns after inserting a chart in a spreadsheet.

In this article, I’ll show you how to create a YOY chart by using Microsoft Excel’s PivotTable and PivotChart features. SEE: Software Installation Policy (TechRepublic Premium) ...