Make Small Changes to a Hand-Drawn Line

Excel

Excel has some excellent drawing tools. In fact, there is a Japanese artist who has created amazing artwork using Excel. But, getting the drawing tools to do exactly what you want takes a little finesse. Here are a few tricks.

First, draw an arc, curve, or scribble. To do this,
1. On the Insert tab, in the Illustrations group, select Shapes.
2. In the Lines you will see Scribble and Curve. In the Basic Shapes you will see Arc. Select the type of line closest to what you want to draw. Scribble is completely free form. Curve has multiple positive and negative curves and Arc has a single arc in one direction.
3. After you select the type of line, draw that line by dragging across the worksheet where you want the scribble, curve, or arc.
4. Release the mouse at the shape’s end point. End an arc by double-clicking.

To fine-tune your shape, right-click on the shape and choose Edit Points.

Black and/or yellow squares will appear along the shape. Depending on the type of shape you have drawn you will be able to drag points on the shape to a new location or “bend” the curve to a new shape.

You can add edit points to a line or curve you draw, then drag those points to change the shape.

You can add edit points to a line or curve you draw, then drag those points to change the shape.

• Drag small black boxes to move a line to a new location.
• Drag yellow boxes at the end of a connected line to reshape a curve.
• Right-click on the line or curve to get additional choices such as Add a Point, Smooth, etc.

It’s difficult to describe how to draw and shape curves and scribbles. The best thing to do is save your file before you begin, then experiment for a while until you get what you need.

Share the power...