Add Pizzaz To Arrows And Pointers In Excel Spreadsheets

BY STANLEY ZAROWIN

ADD PIZZAZ TO ARROWS AND POINTERS IN EXCEL SPREADSHEETS
When I do a presentation that includes spreadsheets, I usually use arrows to illustrate the relationship between numbers, and while it works OK, it lacks pizazz. Is there some way I can add more impact to my spreadsheets?

There are lots of things you can do—such as adding color, size and shape. Let’s look at the options. If you’re using Excel 2007, click on Insert and then on Shapes, which produces this menu:

Once you click on a shape, the Home Ribbon switches to Format and, depending on which shape you select, that menu automatically adjusts to the special options for your selection (see screenshot below).

Not only do you have many choices, but each shape is easily adjustable, for example, by grabbing its edge with your cursor and reshaping it, say, from…


this...
...to this.

In Excel 2003, however, you have fewer options and the customization steps are not as convenient. Begin by clicking on View, Toolbars, Drawing and then go to the bottom of the screen and either click on the simple arrow in the toolbar or click on AutoShapes, and then Lines if you want still more choices…


…or Block Arrows if you want an arrow that you can make a bit fancier…

and click on your selection. Now move your cursor to where you want it to appear in the worksheet and click. If you choose Block Arrows, you can customize some of the choices by clicking and dragging, for example:

from this...
...to this.

Now, to gussy it up further, go to the toolbar on the top of the screen and click on Format, AutoShape and this screen will appear:

Make sure the Colors and Lines tab is selected, and now you can customize both the arrow line and arrowhead. You also can choose whether and how much you want the arrow image to be transparent so the data below can show through.

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.