How to Change Series Data in Excel. To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your ...

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.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply ...

In the Select Data Source dialog, click January (in the list to the right). Then, click Edit. In the resulting dialog, reference the axis label’s dynamic range, DynamicChart1!MonthLabels. Click OK.

Click the "+" sign at the bottom of Excel 2013 to create a new sheet to use as a data source. Enter the values you need for the first drop-down list in column A on the new sheet.