In this video I answer a user's question -How do I use Pivot Tables to group Excel data into half hour time intervals and then display it as a chart?-. The solution is a simple method of using a helper column to determine the time intervals and then employing a Pivot Table or Pivot Chart to automatically aggregate the data and produce a perfect summary.
