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:
Share your thoughts in the comments
Please Login to comment...