Creating Infographics with Excel
Last Updated : 29 Dec, 2021
Infographics are the best option to capture user attention and effectively convey the information.
We explain step by step how to create a simple infographic for displaying sales of Apples and Oranges with a background Grey image.
Implementation:
Follow the below steps to implement the infographics of the sales data:
Step 1: Open Excel.
Step 2: Go to Insert >> Icons.
Step 3: Select Apple and Orange then press Insert
Step 4: Select both icons, Fill White color and Black outline.
Step 5: Duplicate both icons and change fill color.
- Select Apple Icon, Fill “Dark red” color
- Select Orange Icon, Fill Orange color
Step 6: Prepare sample data table as below with background series (Actual data are in row 2).
Step 7: Select the data table and insert Clustered Column.
Step 8: Now we have four bars in the Graph and respective four icons.
Step 9: To Copy the icon image to the bar.
- Copy red apple icon: Select respective (first) bar in graph and right click, Press “Format Data Point”
Step 10: In the “Format data point”.
- Select “Fill & Line” (1); Select “Picture and texture fill” (2); Click Clipboard (3); Select “Stack and Scale with” (4); set 100 to Units/Picture (5)
Step 11: Follow step 9 and 10 to fill all other three bars.
- Black apple icon for second bar.
- Orange colored orange icon for third bar.
- Black orange icon for fourth bar.
Step 12: Select Vertical axis, Right click and click “Format axis”.
Step 13: Select “Axis Options” >> Set minimum to 0 and Maximum to 100.
Step 14: Delete “Vertical Axis” and Chart title.
Step 15: Select “Background” series in graph. Right click and Select “Format Data Series”.
Step 16: In the “Format data series”.
- Select “Series options” (1); Set 100 to Series Overlap(2) and 0 to Gap width (3)
Step 17: Select “Background” series in graph. Right click and Select “Select Data”
Step 18: Select “Sales” in Select Source Dialog box, and Press “Move down” – to send background series to back.
Output:
Similar Reads
Perl | Creating Excel Files Excel files are the most commonly used office application to communicate between computers. It is used to create rows and columns of text, numbers, and formulas for calculations. It is a good way to send reports. This demonstration works on Linux, Windows and other platforms as well. In excel, rows
3 min read
How To Create A Pictograph In Excel? The Pictograph is the record consisting of pictorial symbols. Generally, in mathematics, it is represented by the help of graphs with pictures or icons representing certain quantities or numbers of people, books, etc. It is also known as pictogram, pictogramme, pictorial chart, picture graph, or sim
3 min read
Formatting Charts in Excel One of the major uses of Excel is to create different types of charts for a given data set. Excel provides us with a lot of modification options to perform on these charts to make them more insightful. In this article, we are going to see the most common "Formatting" performed on charts using a suit
3 min read
Programming Charts in Excel VBA VBA stands for Visual Basic for Applications and it is developed by Microsoft. MS Excel and many other Microsoft applications like word, access, etc have this language integrated into them using which one can do various things. VBA can be used in MS Excel through the code editor in its developer tab
4 min read
How To Create Dot Plots In Excel? A Dot plot is a type of chart used in statistics for representing relatively small data sets where the values are uniquely categorized. A dot plot is also known as dot chart or strip chart. A dot plot and a bar graph are similar in the sense that the height of each “bar†of dots is equal to the numb
2 min read