How to Change Series Data in Excel. ... applying the Chart Filters and the Select Data Source options will ... To reposition the data series, click the "Move Up" or "Move Down" arrow buttons.

Your data is now a formatted Excel table, with filter buttons added to your column headers. Change the Table Design Once your table is created, it's time to adjust its layout.

When data is hidden in your table, Excel does not show that information in the chart. Follow the steps below to show charts with hidden data cells in Excel. Select the chart, then click the Chart ...

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...

A “Select data source” window will open, with “Start date” already listed as a series. Click the “Add” button under “Legend entries (series),” and an “Edit series” window will ...