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.