+2 votes
in Class 9 by kratos

How are charts created in Excel? Write the steps.

1 Answer

+4 votes
by kratos
 
Best answer

Creating a Chart:

Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:

  1. Select the data that you want to show, including the column titles and the row labels.

  2. Then click the Insert tab and in the Charts group, click the Column button. You could select another chart type, but column charts are commonly used to compare items.

  3. After you click Column, you’ll see a number of column chart types to choose from. Click Clustered Column, the first column chart in the 2-D Column list.

A ScreenTip displays the chart type name when you rest the pointer over any chart type. The ScreenTip also provides a description of the chart type and gives you information about that, when to use each one.

If you want to change the chart type after you create your chart, click inside the chart. On the Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

...