Inserting Smart Art in Excel can significantly enhance the visual appeal of your spreadsheet data. This feature allows you to transform textual information into various shapes and designs, making it more engaging and easy to understand. Here's a step-by-step guide on how to insert Smart Art in Excel.
Before we dive into the process, ensure you're using Microsoft Excel 2010 or later versions, as this feature is not available in older versions.
Accessing the Smart Art Gallery
To begin, you need to access the Smart Art gallery in Excel. This gallery houses a wide array of designs that you can use to display your data.
Here's how to open the gallery:
1. Select the cell where you want to insert the Smart Art.
2. On the Home tab, under the Styles group, click on the Format as Table button.
3. In the Create Table dialog box, ensure the data range is correct and check the My table has headers box if your data has headers.
4. Click OK to convert your data range into a table. A table icon will appear next to your table's name.
5. Click inside your table to active it. Then, on the Design tab under Table Tools, look for the Tools group and click on the Chart Layout button.
6. In the drop-down menu, select SmartArt to open the Smart Art gallery.
Choosing a Design
Once the Smart Art gallery opens, you'll see various design categories. These categories include Branches, aterractions, Cycle, List, Matrix, and more. Each category displays a range of designs that fit its theme.
To choose a design, simply click on it. The design will automatically populate with your table's data. If you're not satisfied with the chosen layout, click Swap to change the layout style. If you want a specific design, you can find it by browsing through other categories in the gallery.
Customizing Smart Art
After selecting a design, you'll notice that each shape in the Smart Art contains a branch of your table's data. To customize your Smart Art, you can:
1. Add or remove shapes by clicking and dragging the microorganisms at the bottom of the Smart Art panel. Add more shapes to include all your table's data, or remove shapes to show only the most relevant information.
2. Change the layout orientation by clicking the Layout button in the SmartArt tab under SmartArt Tools. This button provides options to organize your Smart Art vertically or horizontally.
Using Built-in Text Boxes
Some Smart Art designs come with built-in text boxes. These allow you to add additional details or highlights to your Smart Art. To access the text boxes:
1. Click inside your Smart Art to activate it. The SmartArt tab will appear under SmartArt Tools.
2. Select the Design Tools tab under SmartArt Tools.
3. Look for the Add Shape button, which looks like a small rectangle with a plus sign inside. Clicking this button adds a new shape to your Smart Art, along with the built-in text box.
Changing Text Box Styles
Once you've added text boxes, you can change their styles to match your Smart Art design. To do this:
1. Click on a text box to select it. A new Text Box tab will appear under Drawing Tools.
2. Click on the Text Box tab and select the fill, line, and effect styles that best match your Smart Art. You can find these in the Shape Fill & Line and Shape Effects groups.
Creating a professional and visually appealing Excel spreadsheet has never been easier with Smart Art. Now that you know how to insert and customize Smart Art, you're ready to take your data presentations to the next level. Keep exploring the various design options and functionalities to make your workstand out.