Question:

A company wants to present its sales data for last five years in a graphical form using MS Excel. As a student of Computerised Accounting, state steps to create a chart in Excel to represent the data visually.

Show Hint

Enter the sales data with column titles, insert a chart from the Charts group, then change its layout and style, add titles and labels, set legend and gridlines, and finally move, resize and save it.
Updated On: Oct 26, 2026
Show Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

Concept:
The company has sales figures for five years and wants a picture of them.
A chart does this job. In MS Excel a chart is built from data already typed in worksheet cells.
The six marking points are listed below in the order they are done.

Step 1: Enter the data in a worksheet:
Type the years in one column and the sales amounts in the next column.
Give each column a proper title, for example Year in cell A1 and Sales (Rs.) in cell B1.
Clear row and column titles let Excel label the chart axes on its own.

Step 2: Create a basic chart:
Select the data range, titles included.
Go to the Insert tab and open the Charts group on top of the worksheet.
Pick a chart pattern such as column, line or bar, and click it. Excel draws the basic chart.

Step 3: Change the layout or style of the chart:
With the chart selected, use the Chart Tools tabs.
Apply a predefined chart layout and a predefined chart style.
Change the layout of the chart elements and the format of the chart elements, such as colours and fonts.

Step 4: Add or remove titles and data labels:
Add (or remove) a chart title so the reader knows what the chart shows.
Add (or remove) axis titles. A title can also be linked to a worksheet cell.
Add (or remove) data labels to show the sales value on each column or point.

Step 5: Show the legend, axes and gridlines:
Show or hide the legend as needed.
Display or hide the chart axes, the primary axis and the secondary axis.
Display or hide the gridlines.

Step 6: Move, resize and save the chart:
Drag the chart to the position wanted on the sheet and resize it by its corner handles.
Then save the workbook so that the chart is kept.

Final Answer:
The chart is made in six stages: enter data with titles, create a basic chart, change layout or style, add or remove titles and data labels, show or hide legend, axes and gridlines, and move, resize and save the chart.
Was this answer helpful?
0
0