News

When there is data that is hidden in your table, Excel will not show that information in the chart. Skip to primary navigation; ... A Select Data Source dialog box will open.
Select "Chart Filters," and then choose "Select Data" to open the Select Data Source dialog box. Select the series in the Legend Entries (Series) box, and then click "Edit" to open the Edit Series ...