Question

State steps to be taken in preparation of a chart.

Answer 1

Following are the steps prepare a chart:

Step – 1: Enter data in a worksheet with proper column and row titles.

Step – 2: Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups’ option.

Step – 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.

Step – 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.

Step – 5: Show or hide a legend.

Step – 6: Display or hide chart axes or gridlines. Display (hide) primary axes, Display (hide) secondary axes, Display (hide) gridlines.

Step – 7: Move (resize) a chart

Step – 8: Save a chart