An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.

To create a chart in an Excel report sheet ... In the Create PivotTable dialogue, in the Table/Range field, select the range of data you want to analyze. In the Location field, select the first ...