Naming a cell or a range of cells in Excel is straightforward. Simply select the cell or range you want to name, and replace ...

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

Adding a Series to an Excel Chart. Microsoft Excel 2013 charts are dynamic in that they automatically update when the current data changes. However, if you add a series of data points to a ...

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.

One way to improve your spreadsheet is to present data in chart form, and Excel is a great program for doing just this. However, Excel's overwhelming number of menus often results in some of the most ...

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.

Explore Excel’s advanced chart types Charts are great for visualizing and presenting spreadsheet data, and for gaining insights from it.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Matching One Column Data with Another in Excel. If you don't have a keen eye and a perfect memory, you probably can't spot all the differences between two data columns in a large worksheet.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).