Looking for methods to create a flow chart in  Excel 2010, just follow the easy steps shown in this video.

Steps:

  • Open Excel
  • Click on insert tab  and go to the illustration group and then click Shapes .
  • Then select any shape on the flow chart section
  • Create the shape on the worksheet by clicking and dragging the mouse .
  • Insert more shapes from the insert group to complete the flow chart layout .
  • Select the desired shapes and align them by pressing the control key on your keyboard .
  • Now go to the arrange group , click align and choose the alignment option of your choice .
  • Repeat the same process to align the other shapes .
  • To add any text on the shape , select any shape and then right click on it and select add a text .
  • Type the required text in selected shape .
  • Repeat the process on other shapes .
  • Select the text box of any shape and then go to the home tab .
  • Choose thebasis text option from text box
  • Follow the same procedure for other text boxes of flow chart .
  • To add lines and arrows on the flow chart , go to the insert tab , click shapes and in the line section choose the preferred options .
  • You can create the shape by clicking and dragging the mouse.
  • Repeat the same process to create more lines in flow chart .
  • To edit the outline of the line or arrow select it and the shape styles group click shape out line.
  • Click on weight and then choose the line option , repeat the same option .
  • To change the style of the shapes of flow chart select the shape .
  • Open the shape style menu  and then choose the option of your choice .
  • Repeat the same process to change the style of other shapes in flowchart .
  • Done .