Today’s infographic chart tutorial will be all about spectacular data visualization. Excel – like many of times before – will be our help in carrying out this task.
To assemble a captivating Excel infographic we can use vector objects, dashboard widgets, drawings and texts, although infographics is more than a simple photo, more complex than a drawing and more informative than a modest chart or a printed out document.
A well-chosen infographics is attention grabbing! It shows for example the position of a product in a given region in a creative and easy to understand way. Furthermore the achievement of a sales representative on a given department, and even a resume can be made in this format.
The creation of an infographics chart tutorial is not an easy task because there are millions of variations. We only show a few examples in today’s article and with the help of these you can take the first steps.
The biggest advantage of infographics is that it can display complex connections on a relatively small space.
This is why it is used more and more for copied documents, on the pages of newspapers and it is spread rapidly in the online media. Besides the “traditional” data visualization we can even see 3D infographics these days.
Infographic Chart Tutorial – Battery Chart
Let’s see those few simple steps that can help you create spectacular data visualization.
The trick will be very easy. From the Excel chart types choose the column chart and set its values so that the smallest displayable value is 0 and the largest is 100. This will represent our scale.
The goal here we aiming for is to make a battery chart so let’s find a battery shape that is actually a frame; the inside part of the battery is transparent. We will place the column chart behind this exactly in the position so that the frame covers the chart. So it will appear that the shape and the diagram form unity.
Finally insert a textbox that will display the current value. After that we set the background of the textbox transparent.
This is how simple this is! Would you have thought it based on the animation? We have made another version of this type of chart, you will find this in the downloads.
Dynamic People Chart
Let’s see another example similar to the previous. With the help of Excel let’s plan diagram which is very cool these days. Its usage is wide spread but most importantly typical for the field of HR.
As you will see after downloading the Excel template, instead of the battery shape now we have used a people vector shape and we have rotated the column chart in such way that it fits appropriately.
Infographic Chart Tutorial – Design
Let us give you same general advice for successful realization.
When choosing the subject, decide what Excel tool you would like to use to introduce the desired subject! Some tools: speedometers, key performance indicators, sparklines, charts, conditional formatted shapes, maps, widgets, gauges.
If necessary do selections and focus on information really relevant to the desired subject. Infographics is not made for displaying several pages of text or numbers.
In planning phase sketch up the basis of the line of logic about all the information you’d like to display! This has a very important role, because in spite we want to display the most difficult connections we have to endeavor to clearness and simplicity. You can divide infographics to parts or even smaller or bigger units.
Effective ways to create infographic based visualizations
Use the maximum opportunities Excel has to offer, choose from existing diagram types, or even design yourselves a never before seen chart type. If you regular readers of this blog you could have already seen that we, ourselves pushing the limits of Excel and we plan and create dashboard templates.
Also belongs to insistent implementation that we should choose models, colors and fonts that possibly fit the subject.
Use ingenious solutions for displaying information! For example for represent proportions you can use figures or icons instead of numbers, best to display more figures for larger amounts.
Additional training materials
In our former article when we made social media dashboards the names of various social sites wasn’t written out, but portrayed by their well-known logotype. This also can be an excellent solution. If you want to track a progress use a progress circle chart!
You can also underline some prominent key information with subtitled labels, or for example you can assemble a creative Excel diagram to introduce otherwise boring number-data or figures.
We hope that with the help of infographic chart tutorial you get into the mood to communicate information in a more spectacular way from now on. Thank you for visiting the blog, you can download the template by clicking on this link.