• 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 Gantt Chart

Excel Gantt Chart

May 22, 2013 by Mynda Treacy

Gantt charts are commonly used in project management and while Excel doesn’t have a native Gantt chart in its chart library we can easily create one. Don’t get too excited, it’s a very basic one. If your job involves complex project management then you probably need a more sophisticated tool like Microsoft Project. However, for …

Read moreExcel Gantt Chart
Excel Step Charts

Excel Step Charts

April 25, 2013 by Mynda Treacy

I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we are at a lookout on a snowmobile trip we took. Anyway I digress…. one of the key pieces of information you want to know as a skier (or snowboarder) is how much snow is on …

Read moreExcel Step Charts
Worlds Most Accurate Pie Chart

World’s Most Accurate Pie Chart

March 13, 2013 by Mynda Treacy

As fun as this chart is, it actually makes a valid point and that is; pie charts are (typically) not very useful. Why? They’re slow to interpret because they usually have too many slices with teeny weeny labels on stalks. You know the ones….like this: Nine times out of ten there are better charts to …

Read moreWorld’s Most Accurate Pie Chart
top 5 mistakes with excel reports

Top 5 Mistakes With Reports in Excel

October 25, 2011 by Mynda Treacy

There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some of us are still making these mistakes. Are you? The good news is they're easily fixed. Mistake 1. Create reports that take a long time to update. I’ve done it before.  I’ve I imported the …

Read moreTop 5 Mistakes With Reports in Excel
Create a Pivot Table Direct From Access

Create a Pivot Table Direct From Access

August 17, 2011 by Mynda Treacy

Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data first? If you use Access then this is a great productivity booster because once you connect to your Access query you simply refresh the data connection and your Pivot Table updates, as do any charts …

Read moreCreate a Pivot Table Direct From Access
Excel Chart Axis Label Tricks

Excel Chart Axis Label Tricks

August 10, 2011 by Mynda Treacy

So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look at our options to make this better: Chart Axis Alignment We could use the alignment tools. Right-click axis > Format Axis > Alignment. But before you waste time doing this there is a better way. …

Read moreExcel Chart Axis Label Tricks
Excel Chart Secondary Axis

Excel Chart Secondary Axis

August 3, 2011 by Mynda Treacy

One of the Excel questions I get asked often is; how do I add a secondary axis to my chart? It’s actually quite easy but there is a trick to it. Excel Secondary Axis Trick Step 1 Let's take this data. Now, the first thing you want to do is simply insert your chart. Insert …

Read moreExcel Chart Secondary Axis
Excel Histogram Charts and FREQUENCY Function

Excel Histogram Charts and FREQUENCY Function

July 20, 2011 by Mynda Treacy

A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into groups. Since my 5 year old is big into his football (soccer) we’ll take goals scored as an example…even though in 5 year old's football matches you’re not supposed to count the goals scored! Below …

Read moreExcel Histogram Charts and FREQUENCY Function
  • Previous
  • Go to page 1
  • Interim pages omitted …
  • Go to page 7
  • Go to page 8
  • Go to page 9
  • 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.