How to create a diagram in Microsoft Excel using SmartArt

This simple diagram was designed using Excel 2010 Smart Art. It's an excellent tool to create quick but effective diagrams. These diagrams can help you explain a concept without having to write a thousand words.
This simple diagram was designed using Excel 2010 Smart Art. It's an excellent tool to create quick but effective diagrams. These diagrams can help you explain a concept without having to write a thousand words.

How to create a professional diagram in excel

SmartArt is a function within Microsoft Excel 2007 and 2010 that allows you to create quality diagrams that include cycles, list, hierarchies and many other types of professional diagrams.

This article describes how to create a diagram in Excel using Smart Art. A diagram that looks professional can be a very useful tool in promoting a point within an article, or to explain a concept without having to write a thousand words. The old adage holds true 'A picture says more than a thousand words'

Article writing is an art form that often requires the writer to step outside the box and add something intriguing and new to get their work noticed; this could be a video, a photo, a table or even a diagram.

Educational and information articles can especially benefit from multi media additions to an article, and there are many professional tools that can be used to create stunning and effective enhancements to a website.

However, not many people realize that they have a very easy to use tool in their office. Microsoft Excel 2010 has some exciting features that can produce some very impressive diagrams.

Microsoft Office Home & Student 2010 - 3PC/1User [Download]
Microsoft Office Home & Student 2010 - 3PC/1User [Download]

This comes with Word, Excel and Powerpoint. Microsoft Office has become more than a simple office product and has features that are very useful for home users.

It's easy to use and even beginners will be able to create decent documents, worksheets and presentations with little or no experience. With a license to use Office on three PCs this is a great price for this excellent office suite.

 

How to create a diagram in Excel- Step 1 - The Concept

Before you even start working within Microsoft Excel, you should read your article and decide what type of diagram would be useful. As an example, in a recent article I wrote entitled Symptoms of a poor article design I wrote about the problems you could have when writing articles, what constitutes a bad design and what you can do to fix some of the inherent problems of a poor article. To illustrate my points I created a diagram to show the cycle I go through as I design and maintain articles.

Before I even opened up Microsoft Excel I wrote some bullet points on a piece of paper. After some editing and revising I came up with a general list of the process I go through:

  • Define / Refine Concept
  • Research Content and Keywords
  • Write Article
  • Review Article
  • Analyze Results

Right away I understood that this was a cycle so I already had an idea of what the final diagram would look like.

SmartArt Dialogue Box - this is where you can choose the design that you want to use. You can change the design at any time.
SmartArt Dialogue Box - this is where you can choose the design that you want to use. You can change the design at any time.

How to create a diagram in Excel- Step 2 - The Process

Now that I have a basic idea of what I want to present within my article I can start creating my diagram in Excel 2010 using Smart Art. Below you will find step by step instructions, I have also created a video tutorial which shows you the full process and more:

  • Open Microsoft Excel 2010.
  • Click the Insert Menu item - this menu has a lot of very useful tools including clipart, graphs and Smart Art.
  • Click Smart Art- this will open a dialogue box - tis is where you chose the design template.
  • Choose the Smart Art type on the left sub menu - as I'm designing a 'cycle' I clicked on Cycle
  • You can now click on the different Smart Art icons - I chose to use the Segmented Cycle as I click on each type I am presented with a brief description of the Smart Art - this helps me decide which Smart Art template to use.

Editing the text - you can return here to add or delete text as you continue the design process
Editing the text - you can return here to add or delete text as you continue the design process
  • On the type your text section I began to enter my previously defined text - by pressing enter I was able to add more segments. You can always come back to edit, add or delete text so don't worry too much if you make errors or are only in draft mode at the moment.
  • With the text completed I started changing the Smart Art Styles - this is where the fun begins. You can customize just about everything on the Smart Art, ranging from the text color and effects, to actually moving the parts of the diagram around.
  • I chose to use the Inset Style- this gave it a nice professional feel - howeve the colors were the same and it looked a little flat.
  • I clicked on change colors and changed it to Gradient Range - Accent 1
  • Now I was happy with the design I clicked on View in the menu and unselected the grid lines.
  • You can't save the diagram directly, so by removing the gird lines I am able to take a screen shot and edit this in paint or any other image manipulation program.
  • Using the screen printfunction of Windows (Alt-Print Scrn) I copied and pasted the worksheet into Paint and cropped it.

 

Video Tutorial: How to create a diagram in Excel 2010 using Smart Art

Final Diagram created in Excel 2010 using Smart Art
Final Diagram created in Excel 2010 using Smart Art

How to create a diagram in Excel- Step 3 - Publish

So there you have it, you've created your first diagram in Excel 2010 using Smart Art. You now have a diagram that can be uploaded to you articles. These diagram can replace a huge chunk of text and really enhance the look and feel of your article.

I note that the Smart Art feature is also available in Excel 2007 and the process is identical. So go and be creative and add a lot of value to your articles. They add that touch of quality that might just set your article apart and lead to decent viral traffic.

More by this Author


Comments 3 comments

My SciFi Life profile image

My SciFi Life 5 years ago from London, UK

voted up & useful as I'm sure I'll be able to bring this functionality to bear in my work! Thanks for laying it out so easily and clearly.


SimeyC profile image

SimeyC 5 years ago from NJ, USA Author

My SciFi Life: thanks! I was tinkering with Excel for a report at work and suddenly realized how useful Smart Art could be for my articles on here!


Zubair Ahmed profile image

Zubair Ahmed 3 years ago

Thank you for sharing this hub, very useful the smartArt feature in MS Office. I tend to use it quite allot in my work.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working