Follow the steps below to show charts with hidden data cells in Excel. Select the chart, then click the Chart Design tab. Click the Select Data button. Click the Hidden and empty cells button.

Bar charts show data with horizontal bars, while column charts use vertical bars. These charts are great for comparing different datasets or monitoring changes over time. See below for an example of ...

Pie charts also work well for displaying discrete data, as all the values combined equal 100 percent of the total. Because of this, pie charts are also a good way to display your values as ...

Chiqui Esteban is the Deputy Director for Art, Maps, and Graphics at National Geographic magazine. Data Points is a new series where we explore the world of data visualization, information ...