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 ...

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.

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.

Back in the Select Data Source dialog box, click the Add button again. Then, select the Duration (Days) header in the sheet for Series name.

Select "Data Sources" from the Programs list. Click the "Add" button on the User DSN tab and select "Microsoft Excel Driver (*.xls)." Click "Finish" and then type a name for the source.

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.