But a hidden benefit is the magic it affords your charts. For instance, add a new column of data to the end of a table, and the linked chart automatically expands to add the new data series. Nice.

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Step 1: You’ll need to add your data into the Excel spreadsheet, with each column having its own dedicated title. If you make a mistake with the column heading order, just redo or add a new column.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.