• 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

segmented survey data 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

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

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

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 scroll and sort table

Excel Scroll and Sort Table

February 6, 2019 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. Your user can scroll to see all the records and toggle which column to sort by and set the sort …

Read moreExcel Scroll and Sort Table
Excel Five Star Rating Chart

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
Excel Power Query Pivot Chart

Excel Power Query Pivot Chart

November 15, 2018 by Mynda Treacy

The options in the Pivot Chart library are limited, which you’ll know if you’ve ever tried to create a Scatter chart. Last week we looked at a workaround to create a scatter chart from a PivotTable, which is great if you want to use Slicers. However, we can also create an Excel Power Query Pivot …

Read moreExcel Power Query Pivot Chart
Excel Scatter Pivot Charts

Excel Scatter Pivot Chart

November 8, 2018 by Mynda Treacy

Ok, that title is a lie. There’s no such thing as an Excel Scatter Pivot Chart. It’s like mixing water and oil. They just don’t go. However, in this tutorial I’m going to show you a way you can defy Excel and trick it into building a scatter chart from a PivotTable. And not only …

Read moreExcel Scatter Pivot Chart
line_vs_dots_thumb

Excel Line Charts vs Dot Plot

November 1, 2018 by Mynda Treacy

A common chart mistake is to use a line chart for the wrong type of data. An example of that is the chart below that has categories* along the horizontal axis: *This chart displays the degree of difficulty each sport requires for the categories above, as judged by a panel of 8 experts made up …

Read moreExcel Line Charts vs Dot Plot
Excel Chart Titles

Excel Chart Titles

August 21, 2018 by Mynda Treacy

Excel Chart titles are often a wasted opportunity to connect with your audience and drive home your message. So, let’s look at some ideas for how we can leverage the chart title to help you and your audience get the most from the chart. Watch the Video Ideas for Excel Chart Titles Keep in mind …

Read moreExcel Chart Titles
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • 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.