• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Infographic Tools

You are here: Home / Excel Dashboard / Excel Infographic Tools
excel infographic tools
February 9, 2023 by Mynda Treacy

In this tutorial I’m going to share with you some hidden Excel chart techniques that will make your reports stand out and draw your readers in. These techniques are often used for infographic style reports, but that’s not to say you can’t use them in dashboards or even PowerPoint presentations.

Infographics are a one off brochure style of report that is designed to impart information quickly and clearly. They often use a combination of pictures, charts, and text to tell a story that takes the reader on a journey, like the one below which was made entirely with Excel:


Excel Infographics Tools Completed


Note: Microsoft discovered unexpected behavior from having the sketch effect in charts. As a result it will not be available going forward. However, it is still available for shapes.

Watch the Video


Subscribe YouTube

Download Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook and follow along. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Excel Infographic Tools

Watch the video above for step by step instructions.

I used the following tools and techniques to build the infographic above. Starting with setting the colour theme for my Excel file in keeping with my topic, which is bees:


Excel Infographics Tools Setting theme color scheme


This saves me time when formatting because the colours are automatically populated in my colour palettes:


Excel Infographics Tools Palette Colors


I set the background fill colour to a light shade of yellow.

Next, I found an image I could use for my header. I found this honeycomb image from pnghut.com and repeated it to fill the header space:


Honeycomb


I used a text box with the Curlz MT font for the header, and got some Excel icons for the background images (honey pot, bee hive, and bees).

The stylised map of Australia image was created using hexagon shapes (Insert tab > Shapes) that I manually coloured in line with the number of beekeepers to create a visual indication of the scale:


Map of Australia Made from Honeycomb Shapes


To create the charts with a hand drawn effect, I applied a sketched effect to the outlines:


Excel Infographics Hand Drawn Sketch Effect on Shape Outlines


I used Excel Icons to add interest and make it more eye catching. You’ll find the icon library on the Insert tab of the ribbon > Icons. Note: you need to be connected to the internet to download the icons.


Insert Icons from Excel into Infographic


There are thousands of icons, cutout people, stickers, illustrations and cartoon people to choose from.

Selection of Icons, Images, Stickers and Illustrations from Excel

Note: there may be limitations for non-Microsoft 365 subscribers.

More Charting Techniques

For more charting and visualisation techniques, check out my Excel Dashboard course where I take you step by step though how to build Excel Dashboards that dynamically update. And teach you how to build over 20 different charts, many of which aren’t found in the chart library.

excel infographic tools

More Excel Dashboard Posts

ai dashboard design

AI Dashboard Design

AI dashboard design can give you some great ideas for design and color combinations, but it’s not smart enough to create useful reports…yet!
dark theme dashboards

Dark Themed Excel Dashboards

Dark Themed Excel Dashboards enable you to use formatting techniques that make your data pop and get your audience's attention.
excel dashboards custom backgrounds

Custom Excel Dashboard Backgrounds

Custom Excel Dashboard Backgrounds bring a level of polish and professionalism to reports and they’re super easy to create using PowerPoint

Embedding Excel Dashboards in a Web Page

Embedding Excel Dashboards in a Web Page from files on SharePoint or OneDrive for Business or OneDrive Personal.
excel student performance dashboard

Excel Student Performance Dashboard

How to build an Excel student performance dashboard from scratch. Download the completed Excel file for reference.
5 Pro excel dashboard design tips

5 Pro Excel Dashboard Design Tips

Excel Dashboard Design Tips you can use in both Excel and Power BI to ensure your reports and quick and easy to read.
excel interactive personal finance dashboard

Interactive Personal Finance Dashboard

Excel Interactive Personal Finance Dashboard to help you visualise and keep track of and manage where you’re spending your money.

Non-financial Excel Dashboards

Step by step how to build Excel Dashboards with non-financial data. Uses Power Query and Power Pivot to visualise NASA data.

Secrets to Building Excel Dashboards in Under 15 Minutes

Learn how to build interactive, clean and focussed dashboards that communicate the important information you want readers to know.
personal share portfolio dashboard

Personal Stock Portfolio Dashboard

Monitor your stocks with this personal share portfolio dashboard built with Excel using the refreshable STOCKHISTORY function and data types.


Category: Excel Dashboard
Previous Post:ai dashboard designAI Dashboard Design
Next Post:ChatGPT for Excelchatgpt for excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.