Creating Infographics with Excel Last Updated : 29 Dec, 2021 Comments Improve Suggest changes Like Article Like Report 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: Comment More infoAdvertise with us Next Article Creating Infographics with Excel S sk123online Follow Improve Article Tags : Excel Excel-Charts ExcelGuide 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 How to Create an Ogive Graph in Excel? Ogive graph, the name might scare you, but believe me this is very simple to create. The ogive graph is a cumulative frequency graph. The graph is plotted between the fixed intervals vs the frequency added up before. It is a curve plotted for cumulative frequency distribution on a graph. There are t 4 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 How to Create Advanced Charts and Graphs in Excel? Charts, graphics, and images are excellent ways to visualize and convey data, and Excel does the same for us by generating charts automatically. We might occasionally want to go beyond the basic charts that Excel generates for us. Let's learn about advanced charts and graphs used in excel, Advanced 10 min read Types of Charts in Excel Visualizing data is a key part of effective analysis, and Excel offers a wide range of tools to help you present information clearly. Understanding the different types of charts in Excel can help you choose the best way to display your data based on your goals and audience. From simple visuals like 3 min read Exploring Data with Power View in Excel Microsoft Excel's Power View is a complex visualization function that allows users to create graphs, charts, and reports. It makes it simple for organizations to create reports and dashboards that can be shared with stakeholders, managers, and other team members on a daily, weekly, and monthly basis 4 min read Generating Dynamic Charts With VBA in Excel A powerful graph range is an information range that refreshes naturally when you change the information source. This unique reach is then utilized as the source information in an outline. As the information changes, the powerful reach refreshes right away which prompts an update in the outline. The 2 min read Like