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

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

When working with Excel, one would expect that pivot tables, which can be used to summarize values, would automatically update when the data in them changes, as they do in charts, for example. But ...

Learn how to create Wall Street Journal-style charts in Excel, including line charts, radar charts, and heatmaps, with this guide by Kenji ...

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.