A Line Chart with markers will help you oversee the trends or changes over time by different categories. Please follow the steps below to make a line chart with markers:
Step 1: Select the data with category names;
Step 2: Click the "Insert" Tab from the ribbon;
Step 3: Click the "Line with Markers" in the chart area;
Step 4: A Line Chart with markers will be created.
Step 5: Change Chart Title: click on the title then select the words inside the box 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.
Another method is to right click on the axis, select Format Axis from the dialog box to bring up Format Axis Window. Please note that Excel 2010 or earlier versions has a different style of the "Format Axis" window.