1.

Explain the steps involved in drawing a chart in excel.

Answer»

A chart is a pictorial representation of data. The data is first entered in a worksheet in a table format. The table shall contain a heading followed by the numerical values.

The steps in creating a chart are as follows;

Step 1:

Data is entered in the cells of an Excel spreadsheet.

Step 2:

Mouse is used to highlight the block of cells containing data, and then insert chart is clicked on. 

Step 3:

When the chart wizard comes up, column or bar graph and a sub type as clustered or stacked type is chosen as per requirement.

Step 4:

If the user wants to switch what appears on the X and Y axis, right clicking on the bar graph, then on ‘ Select Data,’ and finally on ‘Switch Row/Column’.

Step 5:

Labels and legends of the chart an bead justed if needed. User can on the bar graph, and then click the ‘Layout’ tab. Here you can choose what layout you prefer for the chart title, axis titles, and legend.


Discussion

No Comment Found

Related InterviewSolutions