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.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.