how to draw arrows on a chart in Excel?

Question

I have these line graphs I created, and I would like to add arrows to indicate some points on the graphs. I tried adding an "add arrow" button to my tool bar, an when I click on it, it shows me a list of styles of arrows. But I cannot do anything with it! I cannot even chose a style of arrow. I'm stuck. Anybody know how to draw arrows? Thanks!

Answer 1

Display the "Draw" toolbar -- View, Toolbars, Drawing
click on the arrow button
hold the shift key and drag a line with arrow (shift drag will draw a straight line)

after you have the arrow, click the styles button and select the style you want.

when finished, right-click on the arrow and select "order"
choose "put on top"
now drag it into place

Answer 2

Add or remove arrowheads
Instead of pasting or deleting arrowheads on lines, change the line style to reflect the format you want.

Select the line you want to change.
You can only add an arrowhead to a line or connector line.

On the Drawing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, use the Customize dialog box (point to Toolbars on the View menu and click Customize). To see more buttons, click Toolbar Options at the end of the toolbar.), do one of the following:
To add one or two arrowheads, click Arrow Style , and then click the style you want.
To remove all arrowheads, click Arrow Style , and then click Arrow Style 1 (no arrowheads).