A Line Chart will help you oversee the trends or changes over time by different categories. Please follow steps below to make a line chart:
Step 1: Select the data with category names;
Step 2: Click the "Insert" Tab from the ribbon;
Step 3: Click the "Insert Line or Area Chart" in the Chart area;
Step 4: A Line Chart will be created.
Step 5: Change Chart Title: click on the title then select the words to replace with the proper ones;
Step 6: Add Data Labels: Right click any portion of the line, in the dialog box, select "Add Data Labels" then "Add Data Labels" or "Add Data Callouts".
Notes: Excel 2010 and earlier versions have no option of "Data Callouts".
Step 7: Format Axis: double click on the Axis, in the Format Axis window, change the values to make chart changes.
Alternatively, click "Format Axis" from the list, then change values in the Format Axis window.