Excel provides a variety of graphs to display qualitative and quantitative information. After you organize your tally table and input your values, you can create a chart with Excel's built-in tools.

Excel looks at the dates and assumes that all dates form part of the series, whether or not they are entered in the spreadsheet. Assuming that the dates form the X-axis, as you create the chart ...