• 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
    • 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
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Charts

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

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 scatter charts

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

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

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

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

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

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 Charts

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
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Interim pages omitted …
  • Go to page 9
  • Next
  • 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
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

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.