Tuesday, April 26, 2011

How to Make a Flowchart in Excel


1.
Make the 'Drawing' toolbar available in Excel 2003 by going to the 'View' menu and pointing to 'Toolbars.' Click on 'Drawing'; the 'Drawing' toolbar will appear at the bottom of the window. In Excel 2007, go to the 'Insert' tab of the ribbon and find the 'Illustrations' section.
2.
Click on 'AutoShapes' in Excel 2003 and point to 'Flowchart.' Click on the first shape you want to use and click onto the worksheet to place it in the appropriate area. In Excel 2007, click the 'Shapes' button and choose the shape you want to use first from the 'Flowchart' gallery. Click onto the worksheet and place the shape there. For the best results, begin your flowchart near the top of the worksheet, but leave a few rows in case you decide to add text above it.
3.
Add more shapes to your flowchart in the same manner. You need to have one shape for each step in the process. The position of the shape will depend on when the step takes place, as well as how you determine whether to take the step. For instance, if Step One is a yes or no question, you might put 'Yes' in a shape that is down and to the right of the first shape and 'No' down and to the left. Right-click each shape and click on 'Add Text' to add the information needed.
4.
Add connectors between the shapes. In Excel 2003, click the 'AutoShapes' button and click on 'Connectors.' Choose a connector and click on the first shape. Drag into place, linking the two shapes. In Excel 2007, choose a connector from the 'Shapes' drop-down menu. Connect all of the appropriate shapes.
5.
Format the shapes for more interest and effect. Right-click a shape and choose 'Format Shape' (or 'Format AutoShape'). On the 'Font' tab, you can choose a different font, change the font size or color or add effects. On the 'Alignment' tab, you can center your text. On the 'Colors and Lines' tab, you can fill the shape with a color or other fill effect. When you are finished making changes, clck 'OK.'
6.
Save your worksheet. You can use the keyboard shotcut 'Ctrl S.' Print it out if desired.

Blogger news