Explain the procedure to create the chart?

 

 

STEP # 1:
  • Click on INSERT tab

  • Select the required chart type

  • In this example i am selecting CYLINDER type chart

 

STEP # 2:
  • The Movement when i click on chart type CYLINDER, chart box will display on screen

  • Click on SELECT DATA

 

STEP # 3:
  • "Select Data Source" dialogue box will display on screen

  • Click on ADD to add the data for Vertical Axis

 

STEP # 4:
  • "Select Data Source" dialogue box will display on screen

  • Click on ADD to add the data for Vertical Axis

 

STEP # 5:
  • If we click on ADD(above step), "EDIT SERIES" dialogue box will display on screen

  • First i would like to add PURCHASES data

  • Fill the fields with required data

Note:against the "series Name" field instead of typing "purchases" as header name, it is advised to place a cell reference. It gives dynamisam for chart.

 

STEP # 6:
  • Now "Purchases" data has been succesfully added on chart

  • If we have more than one series, again click on ADD

  • In this context i have second series data also, named as SALES

  • Now click on ADD again

 

STEP # 7:
  • Now enter the SALES data in required field

 

STEP # 8:
  • Now vertical axis data PURCHASES & SALES successfully updated

  • Through this setp we have to update HORIZONTAL axis data

  • Click on EDIT

 

STEP # 9:
  • Select the data for HORIZONTAL

  • Now data for HORIZONTAL has been updated

 

STEP # 10:
  • Here is the final screen shot of SELECT DATA SOURCE

 

STEP # 11:
  • Here is the final step in charting process

  • We can edit this chart based on our requirement by using CHARTING TOOLS