www.myonlinetraininghub.com
Open in
urlscan Pro
192.124.249.160
Public Scan
URL:
https://www.myonlinetraininghub.com/category/excel-charts
Submission: On January 30 via api from OM — Scanned from DE
Submission: On January 30 via api from OM — Scanned from DE
Form analysis
1 forms found in the DOMGET 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