79
Replacing Data Markers with Clip Art or Shapes
3. Click and drag to draw an arrow on the worksheet.
4. Right-click the shape and choose Copy
5. Click the data series in the chart. Right-click and choose Format Data Series.
6. In the Format Data Series dialog that appears, choose the Fill category in the left
panel. In the right panel, choose Picture or Texture Fill.
7. In the Insert From section, click the Clipboard button. Excel replaces the columns
with the arrows.
8. Click Close to close the Format Data Series dialog.
This technique works best with 2-D charts. If you attempt to apply a shape to a 3-D col-
umn, the shape is pasted to each vertical ...