Question

6. Write the steps of creating a chart in MS Excel.​

Answer 1

Explanation:

Create a chart

Select data for the chart.

Select Insert > Recommended Charts.

Select a chart on the Recommended Charts tab, to preview the chart. Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. ...

Select a chart.

Select OK.

or....

In this tutorial, we are going to plot a simple column chart that will display the sold quantities against the sales year.

Open Excel

Enter the data from the sample data table above

Your workbook should now look as follows



To get the desired chart you have to follow the following steps



Select the data you want to represent in graph

Click on INSERT tab from the ribbon

Click on the Column chart drop down button

Select the chart type you want

You should be able to see the following chart