Thursday, April 28, 2016

Create beautiful Infographics in Excel - Create and Learn


Infographics are great communication tools and have been used through every media available. You can create beautiful Infographics by using Ms Excel. Try this step by step. Share and let me know if you liked :)







1- Type the words and numbers in Range A1:B2.



2- Go to "Page Layout"' tab, "Sheet Options" and deselect Grid lines View.



3- Select Range A1:B2. Go to "Insert" tab, "Charts" group and select "Doughnut"



 4- Select Legend and press 'Delete" key.


5- Select Chart Title and press "Delete" key


6- Select the chart. Go to "Format" tab, "Shape Fill" and select "No Fill". Go to "Shape Outline" and select "No Outline". 


7- Double-click the series "Woman".


 8- Go to "Format" tab, 'Shape Fill", "More Fill Colors" and select Pink color.



9- Double-Click the series "Man"  and select color "Blue, Accent 1, Darker 25%".


10- With the series selected go to "Format Data Point", "Series Options" and type 81% in Doughnut Hole Size.


11- Go to "Insert" tab, "Text" group and click on "Text Box". 


12- Click and drag to draw a Text Box. With the text box selected type in Formula Bar =B1 to link the B1 value into the text box.


13- Insert a new text box and with it selected type =B2 in the Formula Bar.


14- Select the text boxes and configure them to "Calibri Font", "Size 32", "Center", "No Shape Outline" and "Black, Text 1, Lighter 25%" color.


15- Click and drag the text boxes to the bottom. 


16- Save the 3 images below (Men, Woman and World Map) by right clicking the image and select "Save image as".




17- Go to "Insert" tab, "Illustrations" group, click in "Picture" and select the images that you just saved.

18- Click, drag the images and re-size them as show in figure below.



 18- Insert a new text box and type "Smartphone Users". Move the text box as show in figure below.


19- Congratulations! In few steps you have created a beautiful Infographic.


Extra Help: How to Set Transparent Color:




If you want to learn more about using charts, shapes and pictures to create visual content, try my book "Dynamic Infographic":



If you like the post, please share by clicking on buttons below.









4 comments:

  1. This is very good, I appreciate this.

    ReplyDelete
  2. Excellent work. Please come up with templates other than gender related work.

    ReplyDelete
  3. forms for use in my PowerPoint presentations, however I wanted something more. I was looking for something with a lot of visual appeal. blog comments

    ReplyDelete