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.

Following are the steps to prepare a chart : 1. Enter data in a worksheet with proper column and row titles. 2. Create a basic chart using the pattern from the panel available on top of worksheet in chart groups option. 3. Change the layout or style of chart. Apply a predefined chart layout. Apply a predefined chart style. Change the layout of chart elements. Change the format of chart elements. 4. Add or remove titles or data labels. Add (Remove) a chart title. Add (Remove) axis titles. Link a title to a worksheet cell. Add (Remove) data labels. 5. Show or hide a legend. Display or hide chart axis or gridlines. Display hide primary axis. Display hide secondary axes. Display hide gridlines. 6. Move (Resize) a chart and then save the chart.