Excel shape: Using WordArt and Shape Styles in charts


Using Excel, you created a chart to which you added shapes and text boxes. But now, you’d like to do something to make those chart elements more expressive. You decide you to apply additional formatting to the added shapes and text.

In this learning module, you will be shown how to give inserted shapes and text greater visual impact by formatting with Shape Styles and WordArt.

Excel shape: HOW DOES IT WORK?

To apply additional formatting to your chart’s special elements, first activate the chart by clicking on it once. The Chart Tools context tab along with its subordinated Design, Layout and Format tabs will appear in the Ribbon. Now go the Format tab where additional design options for elements such as text boxes, shapes and data series are located.

In this example, you inserted a block-arrow shape. Now, to format the block arrow, activate it by clicking on it. In the Ribbon, the Drawing Tools context tab appears. Now go to the Format tab under Picture Tools. In the Shape Styles group, you are given a choice of design tools for your selected object:

Excel Shape Style catalog: Choose a style for the selected shape from a style-selection catalog.

Excel Shape Fill: Here you can select a color, gradient, picture or texture to fill the selected element.

Excel Shape Outline: Use this button to change the color, width or line style for the element’s outline.

Excel Shape Effects: For the selected element, you can here choose to apply a visual effect such as: shading, glow, reflection or 3-D rotation.

Since you want to format the block arrow using Shape Styles, you can display all available styles by clicking the More button in the Shape Styles group:

A selection catalog will open. If you move your mouse over the various Shape Styles, you will immediately see how the selected element’s appearance would change. Once you’ve found the desired style, click it.

The style will immediatly be applied to the selected element:

To use WordArt Styles to format the font of the text in the text box, you can either click in the text box – in this case, the cursor will appear in the text box – or you can click the border of the text box to select the entire box.

With the options in the WordArt Styles group, you can now modify the visual style for the text in the text box:

Select a WordArt style from the selection catalog here.

Here you can choose to fill the text with a color, gradient, picture or texture.

Use this button to change the color, width or line style of the outline that surrounds the text’s individual characters.

Use this button to apply a visual effect to the text, such as: shading, glow, reflection or 3-D rotation.

Now, for the current example, you want to apply a WordArt style to the text in the selected text box. Therefore, click the More   button in the WordArt Styles group:


You may choose from among the following options as they appear in the open selection catalog:

Applies to Selected Text: Select this option if you want to format only a selected part of your text.

Applies to All Text in the Shape: Select this option if you want to apply the format to the entire text in the text box.

Clear WordArt: Here you can remove a previously applied WordArt Style.

Excel shape: CAUTION

The Clear WordArt option is only active if your cursor is in the text box or if you’ve selected text in the text box. The option is not active if you selected the entire text box.

Choose the effect you want to apply by clicking on it:

Then click outside the text box. The style will be applied to the text in the text box.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Fatal error: Call to undefined function stc_get_connect_button() in /usr/www/users/soluzi/en_excelhelfer/wp-content/plugins/simple-twitter-connect/stc-comments.php on line 231