Question

prepare a chart on MS Excel spreadsheet and label it for class 7​

Answer 1

The basic steps for creating a chart are the same no matter what type of chart you choose

Step 1

Select the range of cells containing the data (including the column titles and the row labels) to be plotted on the chart.

Step 2

Click on the insert tab

Step 3

Click and select the desired chart category in the Charts group. We will plot a Column Chart for the data series in this example. Click on the Column option in the Charts group. A drop-down list of chart sub­types is displayed.

Step 4

Select the desired chart sub-type. In this case, click on the Clustered Column chart sub-type. The chart appears in the worksheet. Two new tabs, Design and Format, appear in the Ribbon whenever you click on the chart . These tabs contain options for editing and formatting the chart.