Adding Labels and Arrows

The Drawing toolbar contains several tools to further embellish your charts and worksheets. For more information, see "Adding Graphics"

Have you ever been lost in a shopping mall, unable to determine your location or find the store you're looking for? When this happens, it's comforting to find the mall map, with its familiar You Are Here arrow and message that identify your current location and help you get your bearings. As you design your charts, you can use Excel's charting commands to add similar pointers to your own pictures. If you have important aspects that you want to highlight, this could be the perfect tool.

Text and arrows are independent of each other and float freely over the chart where you place them. You can use them individually or together in your charts.

To highlight a chart attribute by adding an arrow, follow these steps:

  1. Display the chart that you want to embellish with an arrow. If the chart is embedded in a worksheet, click the chart to activate Excel's charting commands and tools.
  2. Click the Drawing button on Excel's Standard toolbar. Excel then displays its multipurpose Drawing toolbar, as shown in the following illustration:
  3. click to view at full size.

  4. Click the Arrow button on the Drawing toolbar. The mouse pointer changes to drawing crosshairs.
  5. Draw the line that will be your arrow from the tail to the head of the arrow. When you release the mouse button, a default-style arrow appears.
  6. Customize the arrow by adjusting the weight of the line using the Line Style button, selecting a dashed line style using the Dash Style button, or adjusting the tail and head of the arrow using the Arrow Style button.

To add text to the arrow, follow these steps:

  1. Click the Text Box button on the Drawing toolbar.
  2. Use the drag technique to draw a rectangle to hold your label text. When it's approximately the right size, release the mouse button.
  3. Type the label text, and then click near the border of the text box to select it.
  4. Use the Formatting toolbar to set the font, size, and style of the text. Use the Drawing toolbar to change the color of the text (click the Font Color button), to set the background color of the text box (click the Fill Color button), to add an outline to the text box (click the Line Style button), and to set the color of the outline (click the Line Color button).
  5. TIP
    You can reposition free-floating text boxes and arrows in your chart by selecting them and dragging them with the mouse. To delete a text box or arrow, select the object and press Delete.

  • Resize the text box using the selection handles, and place the text box where you want it by dragging the border. Then click outside the chart area to remove the selection handles. Our chart now appears like the one on the opposite page.
  • Click the Close button on the Drawing toolbar to remove it from the screen. (If you don't see a Close button, right-click the Drawing toolbar and deselect Drawing to remove it from the screen.)
  • click to view at full size.

    Running Microsoft Office 2000 Small Business
    Running Microsoft Office 2000
    ISBN: 1572319585
    EAN: 2147483647
    Year: 2005
    Pages: 228
    Authors: Michael Halvorson, Michael J. Young
    BUY ON AMAZON © 2008-2017.
    If you may any questions please contact us: