Display Or Hide Data Table In Chart. On the Chart menu click Chart Options and then click the Data Table tab. Click the Data Table button and choose an option from the menu.
On the Chart menu click Chart Options and then click the Data Table tab. Click to Show or Hide Excel Chart Data If youre building Excel reports for other people to use you can add a few interactive chart features to let people customize the reports. To display a data table direct your cursor to Data Table and click the arrow beside it and then press a display option.
Click to Show or Hide Excel Chart Data If youre building Excel reports for other people to use you can add a few interactive chart features to let people customize the reports.
Go to the chart Properties and in the Main tab uncheck the Hide Total Values property which applies to chart types other than Pie. By default elements that do not meet the filter criteria applied to a chart will be grouped and displayed in the pie chart in one gray slice. When this property is unchecked grand totals and subtotals are displayed in the chart. Display or hide a data table in a chart.