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.