WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Infographics in Excel

Infographics in Excel

Excel Infographics

Infographics in excel is the way of showing the information or summary report through attractive charts, graphs, and images. In other words infographics are the art of visualizing the data using external elements or images. They are different from dashboards and require the architectural mind to build your own infographics in excel.

Infographics in Excel

How to Create People Graph Infographics in Excel?

Now we will see some of the examples of creating infographics in excel.

You can download this Infographics Excel Template here – Infographics Excel Template

People Graph is the new additional feature available from Excel 2013 versions onwards. This is a graph available with Excel 2013 onwards versions under the INSERT tab.

excel people graph Example 1.png

For example, below is an organization’s departmental manpower, and for this data, we will show you how to create people graph infographics in excel.

 Example 1.1

Step 1 – Copy the above data to the excel worksheet, select the data to go to the INSERT tab, and click on “People Graph.”

excel people graph Example 1.2.0

Step 2 – First, it will show about numbers of this particular app.

Example 1.3

Step 3 – Click on the “Data” icon at the top.

excel people graph Example 1.4

Step 4 – Choose “Select Data”

 Example 1.5

Step 5 – Now, it will show sample data preview, but at the bottom, it shows how many rows and columns in excel are selected. Now click on “Create” to get your first People Graph.

excel people graph Example 1.6

We get the following People Graph.

Example 1.7

Not all the departments are showing here; we need to expand the chart to see all the department data.

From the data, the tab changes the title of the chart.

excel people graph Example 1.8.0

Click on “Settings” options to format the chart.

 Example 1.9

In this “Settings,” we have three options, i.e., “Type,” “theme,” and “Shape.”

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

excel people graph Example 1.10.0

From the type, we can choose a different kind of people graph.

Example 1.11.0

Under “Theme,” we can change the color background of the chart.

infographics in excel Example 1.12.0

Under “Shape,” we can change icons of the chart.

People Graph in excel Example 1.13

How to Use External Images to Create Infographics?

We have seen people graph infographics in excel; we can build infographics by using external images as well. For the same data, we will use a human image from outside excel.

I have downloaded the below human image from the internet into excel worksheet.

infographics in excel Example 2

First, insert a bar chart in excel for the data.

People Graph in excel Example 2.1

Now we have a chart like this.

excel people graph Example 2.2

What you have to do is copy the human image >>> select the bar and paste it.

 Example 2.3

We need to format the chart to make it more beautiful. Select the bar and press Ctrl + 1 to open the formatting tab to the right side.

excel people graph Example 2.4

Make the “Gap Width” as 0%.

Example 2.5

Now go to “Fill” and click on “Fill.”Make the fill as “Picture or Texture Fill” and check the option of “Stack and Scale Width.”

excel people graph Example 2.6

Now our chart looks like this.

 Example 2.7

Now assume we have a segregation of “Male” and “Female” employees.

Infographics in Excel Example 3

In the infographic chart, we need to show male and female human images. I have downloaded male and female images from the internet.

Example 3.1

Select the data and insert the “Stacked Bar” chart.

Infographics in Excel Example 3.2

Now we have a chart like this.

Example 3.3

Copy the “Male” image and paste it on an orange-colored bar.

excel people graph Example 3.4

Copy the “Female” image and paste it on a yellow-colored bar.

 Example 3.5

Select the male bar and format the data series as we did in the previous example. Do the same thing for the “Female” chart as well, and we have a segregation of “Male” and “Female” separately now.

excel people graph Example 3.6

We do one more thing to show male and female employees differently. Arrange the data in the below manner.

 Example 3.7

I have converted male employee’s numbers to, now, we can see male employees to the left and female employees to the right.

infographics in excel Example 3.8

Example #3

Now we will build one more infographic before we wind up this article. Look at the below data of department-wise salary numbers.

 Example 4

For this data, we will build the below kind of infographic chart.

Infographics in Excel Example 4.7

Select the data and insert the Line chart in excel.

 Example 4.1

Now we have a chart like this.

Infographics in Excel Example 4.2

Change the line color and font colors.

 Example 4.3

Copy the below visual from the internet to excel.

Infographics in Excel Example 4.4

Select the line marker now.

Example 4.5

After selecting the markers to paste the copied image.

Infographics in Excel Example 4.6

Now you can add extra elements to the chart as per the requirement.

Recommended Articles

This has been a guide to infographics in excel. Here we discuss how to create infographics (People Graph) in excel using external images along with examples and a downloadable excel template. You can learn more about excel functions from the following articles –

  • Group Rows in Excel
  • Timeline Chart In Excel
  • Create 3D Maps in Excel
  • Create Icon Sets in Excel
6 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Infographics Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More