In this tutorial, we will show a simple trick to show charts with hidden data in Excel ... Select Data feature changes the data range included in the chart. A Select Data Source dialog box ...

To update your Microsoft Excel worksheet ... to display the commands. Select "Chart Filters," and then choose "Select Data" to open the Select Data Source dialog box. Select the series in the ...

Select your database from the Select Data Source dialog ... of the field boxes say “not matched.” Click the down arrow on the right to display the field names used in your Excel database.