www.myonlinetraininghub.com Open in urlscan Pro
192.124.249.160  Public Scan

Form analysis
1 forms found in the DOM

GET https://www.myonlinetraininghub.com/

<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
    id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
      viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
      <path
        d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
      </path>
    </svg></button>
  <meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>

Text Content

My Online Training Hub
Data and Cookie Consent
In order to provide a more personal user experience, we and our 219 partners use
technology such as cookies to store and/or access device information.
By clicking “Accept” you consent to these technologies which will allow us and
our partners
to process non-sensitive data such as IP address, unique ID, and browsing data
for the purposes of serving personalized ads and content, ad and content
measurement, audience insights, and to develop and improve products.
Your choices on this site will be applied only for this site. You can change
your settings at any time, including withdrawing your consent, by going to the
Privacy Policy
page of this site.
Manage Settings
Accept

Update Privacy Settings
 * 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

Menu
 * 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
 * 
 * Search
   Search siteSubmit search
 * Login

 * Courses
 * Pricing Sub Menu
   * 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 Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * 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 Sub Menu
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Register as Forum Member
 * 
 * Login


EXCEL CHARTS


INTERACTIVE PYTHON CHARTS IN EXCEL

August 25, 2023 by Mynda Treacy

One of the best uses for Python in Excel is creating the amazing charts
available through Python libraries like Seaborn and Matplotlib. These libraries
open up a huge array of charts we simply cannot make using the built-in Excel
charts. Get started with Python in Excel here.   Your browser does not support
the video …

Read moreInteractive Python Charts in Excel


EXCEL PROGRESS CIRCLE CHARTS

August 1, 2023 by Mynda Treacy

Progress charts are a powerful way to track milestones and showcase
achievements. However, there’s no built-in way to create Excel progress circle
charts, but with some clever uses of doughnut charts we can whip them up in no
time. In this tutorial we’ll look at how to quickly create them and link them to
Slicers …

Read moreExcel Progress Circle Charts


PRO EXCEL CHART FORMATTING

July 11, 2023 by Mynda Treacy

Charts provide a visual representation of data, making it easier to understand
and interpret large amounts of information quickly. At least that’s the
objective, but too often poor choice of chart formatting is more of a hindrance
than a help. In this tutorial we’ll look at the types of Excel chart formatting
that is an …

Read morePro Excel Chart Formatting


EXCEL SCROLL AND SORT TABLE

June 13, 2023 by Mynda Treacy

Dashboards have limited space which is why an Excel scroll and sort table is
super handy. Scroll and sort tables allow you to embed an extract of data from a
larger table in your Dashboard. Users can scroll to see all the records and
toggle which column to sort by and set the sort order, …

Read moreExcel Scroll and Sort Table


PICTURE FILL EXCEL CHARTS

March 2, 2023 by Mynda Treacy

When building reports, it's important that people not only understand what
you're saying but also remember it. Picture fill Excel charts are a simple way
to make your data visualizations more captivating and memorable. They’re
suitable for infographics and fun reports, but I wouldn’t necessarily use them
in corporate style reports. You can create them …

Read morePicture Fill Excel Charts


EXCEL SPEEDOMETER CHARTS

January 19, 2023 by Mynda Treacy

Excel Speedometer charts or gauge charts as they’re also known, have a worse
reputation in data visualization circles than the disdained pie chart. It’s
primarily because they take up a huge amount of space and ink relative to the
amount of information they convey. In this tutorial we’re going to learn how to
build Excel …

Read moreExcel Speedometer Charts


EXCEL PROJECT MANAGEMENT BURN DOWN AND BURN UP CHARTS

November 3, 2022 by Mynda Treacy

Excel Burn Down and Burn Up Charts are easy to make with line or scatter charts.
If you’re familiar with Agile Project Management, then you’ll know that these
charts are useful for monitoring the progress of a project against expectations.
While the terminology is specific to Agile Project Management, the concept is
relevant to managing …

Read moreExcel Project Management Burn Down and Burn Up Charts


EXCEL WEEPEOPLE FONT CHARTS

October 27, 2022 by Mynda Treacy

Excel WeePeople font charts enable you to build interesting variations on
waffle, bar and column charts, to name a few. They’re great for visualising
demographic data, survey data and more. The free WeePeople font, courtesy of
ProPublica, consists of 20 different people silhouettes hand drawn by Alberto
Cairo. The last 6 letters of the alphabet …

Read moreExcel WeePeople Font Charts


EXCEL DOT MAP CHARTS

October 20, 2022 by Mynda Treacy

One of the things that makes Excel stand apart from other reporting tools is its
immense flexibility. With some tinkering you can make charts and graphics that
don’t look anything like Excel. In this post I’m going to take you through the
steps to create Excel dot map charts. And while there’s no built in …

Read moreExcel Dot Map Charts


EXCEL S-CURVE CHARTS

August 25, 2022 by Mynda Treacy

S-curve charts are a common tool used in project management to track the
cumulative costs, hours, sales etc. over time. The chart forms the shape of an S
because typically progress starts slow and ends slow, with acceleration in the
middle periods. For example, in the s-curve chart below you can see progress is
slow …

Read moreExcel S-Curve Charts


EXCEL CHART AXIS SWITCH

March 24, 2022 by Mynda Treacy

When working with small multiple charts or panel charts as they’re also known,
it’s handy to be able to switch the chart axes between the same axis for each
chart and their own axis. Using the same axis enables you to compare the data
between the charts because they all use the same scale. Whereas …

Read moreExcel Chart Axis Switch


EXCEL CHARTS WITH SHAPES FOR INFOGRAPHICS

January 27, 2022 by Mynda Treacy

You can create more interest and give your charts infographic styling when you
create Excel charts with Shapes. There’s no limit to the type of shapes you work
with, but there are some techniques required to ensure they don’t get distorted
when working with data of different values. Watch the Video Download Workbook
Enter your …

Read moreExcel Charts with Shapes for Infographics


EXCEL PYRAMID CHARTS

February 11, 2021 by Mynda Treacy

Excel pyramid charts are easy to build using bar charts or Conditional
Formatting, but there are a few rules you must follow depending on the approach
you choose. Before we look at the steps, keep in mind that these charts aren’t
limited to visualising gender splits. They’re also handy for any type of
demographic data …

Read moreExcel Pyramid Charts


HIGHLIGHTING PERIODS IN EXCEL CHARTS

January 21, 2021 by Mynda Treacy

Shading or highlighting periods in Excel charts can help users more quickly
interpret them and identify patterns. In the chart below I’ve highlighted every
second month to give a quick visual indication of each period, which allows the
user to focus on the line instead of having to refer back and forth to the
horizontal …

Read moreHighlighting Periods in Excel Charts


STACKED BAR EXCEL WAFFLE CHARTS

December 10, 2020 by Mynda Treacy

Last week we looked at building Excel waffle charts using Conditional
Formatting. This week we’re looking at building Stacked Bar Excel waffle charts.
Some might say this technique is easier, although it may appear daunting when
you look at the number of steps. Don’t let that put you off though, it’s super
easy. The other …

Read moreStacked Bar Excel Waffle Charts


EXCEL WAFFLE CHARTS WITH CONDITIONAL FORMATTING

December 3, 2020 by Mynda Treacy

Excel Waffle Charts are a popular way to visually display parts to a whole. You
can think of them as an alternative to pie and doughnut charts. Waffle charts
are better at displaying small segments that often get lost in a pie chart.
However, that doesn’t mean you should get carried away with the number …

Read moreExcel Waffle Charts with Conditional Formatting


LABEL SPECIFIC EXCEL CHART AXIS DATES

July 9, 2020 by Mynda Treacy

When you have data that spans a long period of time that you want to plot in a
chart, the dates in the horizontal axis in a line or scatter chart can get very
cluttered. With this clever workaround that Jim Fitch shared with me we can
trick Excel into showing data correctly spaced over …

Read moreLabel Specific Excel Chart Axis Dates


JITTER IN EXCEL SCATTER CHARTS

February 26, 2020 by Philip Treacy

If you use a scatter plot for a dataset that has discrete values in one
dimension, for example your x-axis shows the days of the week, you can get
points overlapping when you plot the data. To make the chart easier to interpret
you can introduce jitter to the data points. This means moving the …

Read moreJitter in Excel Scatter Charts


CUSTOM EXCEL CHART LABEL POSITIONS

February 20, 2020 by Mynda Treacy

When you plot multiple series in a chart the labels can end up overlapping other
data. A solution to this is to use custom Excel chart label positions assigned
to a ghost series. For example, in the Actual vs Target chart below, only the
Actual columns have labels and it doesn’t matter whether they’re aligned …

Read moreCustom Excel Chart Label Positions


LOOKUP PICTURES IN EXCEL

February 13, 2020 by Mynda Treacy

We can use a data validation list or a Slicer to lookup pictures in Excel. This
ability to lookup pictures is handy for returning images of products, employees,
logos etc. The only limit is your imagination. In this example I’m going to
lookup pictures of the Tour de France stage profiles*. *Source 2013 Tour de …

Read moreLookup Pictures in Excel


CROSS HIGHLIGHT EXCEL CHARTS

February 6, 2020 by Mynda Treacy

One of the cool features in Power BI is the ability to cross highlight from one
chart to another by clicking on a column in one chart and instantly highlight
the selected item in another, as shown below: We can also cross highlight Excel
charts in almost the same way and without the need for …

Read moreCross Highlight Excel Charts


USING JITTER TO AVOID OVER PLOTTING IN POWER BI

January 11, 2020 by Philip Treacy

If you need to plot data that has one variable where values can be the same or
very similar, for example the age of a group of people, you'll likely end up
with data points that are plotted over the top of each other. To make this type
of plot easier to read and allow …

Read moreUsing Jitter to Avoid Over Plotting in Power BI


EXCEL SMALL MULTIPLE CHARTS

November 19, 2019 by Mynda Treacy

Reduce clutter in busy line charts by plotting your data in small multiple
charts, or panel charts as they’re sometimes known. I’ve used a few tricks for
building small multiples in the past, but the Excel small multiple charts I’m
going to cover in this tutorial are dead easy. It’s all in the layout of …

Read moreExcel Small Multiple Charts


OVERLAY LINE CHART LABELS

November 12, 2019 by Mynda Treacy

Labeling charts is useful if the reader needs to know the exact value for each
point. We can position labels left, right, above, below or overlaid (centred) on
the line. However, when you overlay line chart labels it typically looks messy,
as you can see below: This is easily solved with some formatting to achieve …

Read moreOverlay Line Chart Labels


EXCEL ACTUAL VS TARGET CHART

November 6, 2019 by Mynda Treacy

Often, you’ll find Actual vs Target charts based on categorical data in the form
of a column chart, however they’re slow to read.  Thankfully we can make a big
improvement in how quick and easy they are to read with a few simple changes.
Watch the Video   Download Workbook Enter your email address below …

Read moreExcel Actual vs Target Chart


SEGMENTED SURVEY DATA CHART

August 22, 2019 by Mynda Treacy

Charting survey data can be tricky, and when you want a segmented survey data
chart it adds another layer of complexity. Bart sent me the data below and asked
how I would go about visualising the data to include the size of the segments
(students, lecturers, staff). Segmented Survey Data Chart – Option 1 You …

Read moreSegmented Survey Data Chart


YEAR ON YEAR CHARTS

August 14, 2019 by Mynda Treacy

Year on year charts or data over time is one of the most common data
visualisations you’ll see. However, the message conveyed depends on the chart
you choose. Watch the Video Download Workbook Enter your email address below to
download the sample workbook. Get Workbook By submitting your email address you
agree that we can …

Read moreYear on Year Charts


EXCEL BAR CHART WITH VERTICAL LINE

August 8, 2019 by Mynda Treacy

In this post I’m going to show you a way to create an Excel bar chart with a
vertical line. The inspiration was taken from this Tableau chart by Emily
Tesoriero: Unfortunately, adding a vertical line to a bar chart isn’t a simple
feat in Excel, but I’ll step you through a workaround that’s relatively …

Read moreExcel Bar Chart with Vertical Line


INCLUDE GRAND TOTALS IN PIVOT CHARTS

May 6, 2019 by Mynda Treacy

If you work with PivotTables, then you’ve probably found that you can’t include
grand totals in Pivot Charts, or subtotals for that matter.  And if you’ve ever
created a stacked column chart then you’ll have likely wanted to include grand
totals as column labels, like this: And then remembered you can’t. One
workaround is to …

Read moreInclude Grand Totals in Pivot Charts


EXCEL FIVE STAR RATING CHART

January 30, 2019 by Mynda Treacy

Creating an Excel five star rating chart is easy with Conditional Formatting.
They’re not limited to stars, you can also create column, pie and waffle rating
charts. Constructing an Excel Five Star Rating Chart Step 1: In the top left
cell of your table, in my case cell C5, insert the formula below that calculates
…

Read moreExcel Five Star Rating Chart
 * Go to page 1
 * Go to page 2
 * Go to page 3
 * Go to page 4
 * Next

BLOG CATEGORIES

 * AI in Excel
 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel Office Scripts
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

COMPANY

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


SUPPORT

 * Contact
 * Forum
 * Helpdesk – For Technical Issues

Copyright © 2024 · 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.



64 Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share