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. Skip to primary navigation Skip to main content ...

How to Change Series Data in Excel. ... As an alternative, applying the Chart Filters and the Select Data Source options will enable you to rearrange, hide or remove a data series from the chart.

Click OK to close the Select Data Source dialog box. You will notice that the tasks are in reverse order. We can quickly rectify this by right-clicking them in the chart and selecting Format Axis .

Excel provides the flexibility to pull data from different worksheets, databases, or even external files. Once your data is ready, navigate to the “Insert” tab and select “PivotTable.” ...