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.

Select the two sets of data you want to use to create the graph. Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.

How to Make a Year Graph in Excel. Microsoft Excel 2010 gives you a number of graphing options so you can display the information in your spreadsheet in many different ways. If you are dealing ...