Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Type your data or use existing data from your file. Highlight the range of cells containing your data. Then click the Insert tab and click the Insert Column or Bar Chart button. Click the ...

Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data.

Other versions of Excel may work differently. All the charts and underlying data are available in this Excel file. As you probably already know, to create a chart, you select the data you want ...

Right-click on the chart, select Select Data, and adjust the order if needed. Update Chart Elements: Check that all chart elements like labels and legends are correctly displayed.

Select Your Data Range: Highlight the range of cells that includes the data you want to use for your PivotChart. Insert a PivotTable: Go to the Insert tab on the Ribbon, then click on PivotTable.