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.

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 ExcelFeature Available From Excel The top features of MS excel are - Shortcut keys, Summation of values, Data filtration, Paste special, Insert random numbers, Goal seek analysis tool, Insert serial numbers etc. read more 2013 versions onwards. This is a graph available with Excel 2013 onwards versions under the INSERT tab.

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.

Steps to create an infographics in excel are as follows.

Copy the data to the excel worksheet, select the data to go to the INSERT tab, and click on “People Graph.”
First, it will show about numbers of this particular app.
Click on the “Data” icon at the top.
Choose “Select Data”.
Now, it will show sample data preview, but at the bottom, it shows how many rows and columns in excelHow Many Rows And Columns In Excel Since Excel 2007 to date, we have 1,048, 576 rows & 16, 384 columns. This is a great surge in the numbers compared to the 65, 536 rows & 256 columns for Excel 2003. read more are selected. Now click on “Create” to get your first People Graph.

We get the following People Graph.

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.

Click on “Settings” options to format the chart.

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

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

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

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

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.

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

Now we have a chart like this.

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

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.

Make the “Gap Width” as 0%.

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.”

Now our chart looks like this.

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

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

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

Now we have a chart like this.

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

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

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.