Home / Tech / Excel Basics / 7.4. Working with Excel SmartArt

7.4. Working with Excel SmartArt

When Microsoft Office 2007 is released Microsoft introduced a new feature inside of Excel, Word and PowerPoint. This is a feature that prior to 2007 none of the Office applications had. And this deals with creating more complex diagrams through basic shapes, And this deals with creating more complex diagrams through basic shapes, this is called Smart Art.

Through Smart Art. We can create very fancy diagrams through a couple of simple clicks of our mouse.

I am going to go up to Insert tab top of my screen on the Insert tab We saw illustrations earlier. We had pictures online pictures we had Excel shapes that is where you got some of your basic shapes.

Now in the past if I want to create something like an org chart or maybe a process flow diagram, I would have to use basic shapes and really start to diagram this myself create all the rectangles in the organization chart create the connector lines, It was a huge hassle. Now, Right below the Excel shapes, I have Smart Art and Smart Art are some canned out-of-the-box fancy diagrams.

I will click on Smart Art icon to open Smart Art graphic window. And I have got all these different categories of Smart Art, that I can pick from fancy little diagrams.

I am going to go to a process, and I have got all these process diagrams. I can pick from. I am going to grab this kind of do not circle one here. It is called The Circle X timeline.

So, I got some type of process that I wanted to demonstrate to my users over some timeline through this Smart Art graphic are selected.

Working with Excel SmartArt 1

I can now diagram this process this timeline process through these nice graphical shapes that give

I can now diagram this process this timeline process through these nice graphical shapes. that give me this nice little table here on the left, I can start to manipulate the shapes and the content within those shapes. I would say something like oh you know, if I am going through a document approval process this is over some period. So, my first step in getting a document approved is I got to create the document.

Working with Excel SmartArt 2

Now, this diagram gave me two major steps. However, you know what I think, I need a third one in this creation and approval of the document.

So what I am going to do is after you collect responses ass responses, I will hit my Enter key, this creates a third additional subset, but I do not want to that subset, I want the next major step. up above I have got some additional tools with the smart select that I get two new tabs design and format on the design tab underneath create graphic, I have got the one sublets selected but I am going to promote it, I am going to move it up in the hierarchy.

Working with Excel SmartArt 3

And now I have got a next major step and we will call this line final approval.

I have got this fancy diagram that, I could have created through the simple shapes that we were talking about earlier, but this is streamlined.

Now if you want to do some formatting with this you got all sorts of formatting options. I mean it is like the border. Not a specific shape but just the border. I will go up to my design tab and here I got smart art styles and you got all sorts of styles to pick from and just hover my mouse over the top of these, they are pretty slick.

Working with Excel SmartArt 4

That is a slick one if you want to get into the nitty gritty of formatting your shapes. You are smart are all by yourself.

Working with Excel SmartArt 5

You not to use styles all of those are quick and dirty and just right away you can format your shape but you can also go to the Format tab and you can do all your formatting to your heart’s content.

Try it out. Use a style or maybe hop over to the Format tab and format it on your own.

About admin

Check Also

Excel Decimal Data Validation 1

15.2 Excel Decimal Data Validation

Create the little dropdown give the users the exact values for them to pick from. …

Leave a Reply

Your email address will not be published. Required fields are marked *