Step 1: Enter the data in a worksheet with proper column and row titles
Step 2: Select the range of data using the mouse
Step 3: Click on Insert Tab → Object → Chart. Select a chart type from the “Choose a chart type” list in chart wizard window.
Step 4: Naming chart, X-axis and Y-axis. Click on the chart → Right click → Insert titles (Names) → OK
Step 5: Change the layout or styles of chart.
Step 6: Show or hide a legend
Step 7: Display or hide chart axes or gridlines
Step 8: Move (resize) a chart
Step 9: Save a chart