Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

If you create charts with Excel, error bars allow you to visualize margins of error for data points. Here's how to add error bars in Excel.

Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis.