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.

In Microsoft Excel, you can create a Half Pie Chart if your data range has a total. A Half Pie Chart is a 180 degrees graph that represents a composition as a whole.