Excel Charts Archives • My Online Training Hub

October 1, 2024

How to Choose the Right Chart for Your Data

Charts are one of the best ways to visualize data and communicate insights quickly, but using the wrong chart can

August 25, 2023

Interactive Python Charts in Excel

One of the best uses for Python in Excel is creating the amazing charts available through Python libraries like Seaborn

August 1, 2023

Excel Progress Circle Charts

Progress charts are a powerful way to track milestones and showcase achievements. However, there’s no built-in way to create Excel

professional vs amateur chart formatting

July 11, 2023

Pro Excel Chart Formatting

Charts provide a visual representation of data, making it easier to understand and interpret large amounts of information quickly. At

June 13, 2023

Excel Scroll and Sort Table

Dashboards have limited space which is why an Excel scroll and sort table is super handy. Scroll and sort tables

March 2, 2023

Picture Fill Excel Charts

When building reports, it's important that people not only understand what you're saying but also remember it. Picture fill Excel

January 19, 2023

Excel Speedometer Charts

Excel Speedometer charts or gauge charts as they’re also known, have a worse reputation in data visualization circles than the

November 3, 2022

Excel Project Management Burn Down and Burn Up Charts

Excel Burn Down and Burn Up Charts are easy to make with line or scatter charts. If you’re familiar with

October 27, 2022

Excel WeePeople Font Charts

Excel WeePeople font charts enable you to build interesting variations on waffle, bar and column charts, to name a few.

October 20, 2022

Excel Dot Map Charts

One of the things that makes Excel stand apart from other reporting tools is its immense flexibility. With some tinkering

August 25, 2022

Excel S-Curve Charts

S-curve charts are a common tool used in project management to track the cumulative costs, hours, sales etc. over time.

March 24, 2022

Excel Chart Axis Switch

When working with small multiple charts or panel charts as they’re also known, it’s handy to be able to switch

January 27, 2022

Excel Charts with Shapes for Infographics

You can create more interest and give your charts infographic styling when you create Excel charts with Shapes. There’s no

February 11, 2021

Excel Pyramid Charts

Excel pyramid charts are easy to build using bar charts or Conditional Formatting, but there are a few rules you

January 21, 2021

Highlighting Periods in Excel Charts

Shading or highlighting periods in Excel charts can help users more quickly interpret them and identify patterns. In the chart

December 10, 2020

Stacked Bar Excel Waffle Charts

Last week we looked at building Excel waffle charts using Conditional Formatting. This week we’re looking at building Stacked Bar

December 3, 2020

Excel Waffle Charts with Conditional Formatting

Excel Waffle Charts are a popular way to visually display parts to a whole. You can think of them as

July 9, 2020

Label Specific Excel Chart Axis Dates

When you have data that spans a long period of time that you want to plot in a chart, the

February 26, 2020

Jitter in Excel Scatter Charts

If you use a scatter plot for a dataset that has discrete values in one dimension, for example your x-axis

February 20, 2020

Custom Excel Chart Label Positions

When you plot multiple series in a chart the labels can end up overlapping other data. A solution to this

February 13, 2020

Lookup Pictures in Excel

We can use a data validation list or a Slicer to lookup pictures in Excel. This ability to lookup pictures

February 6, 2020

Cross Highlight Excel Charts

One of the cool features in Power BI is the ability to cross highlight from one chart to another by

January 11, 2020

Using Jitter to Avoid Over Plotting in Power BI

If you need to plot data that has one variable where values can be the same or very similar, for

November 19, 2019

Excel Small Multiple Charts

Reduce clutter in busy line charts by plotting your data in small multiple charts, or panel charts as they’re sometimes

November 12, 2019

Overlay Line Chart Labels

Labeling charts is useful if the reader needs to know the exact value for each point. We can position labels

November 6, 2019

Excel Actual vs Target Chart

Often, you’ll find Actual vs Target charts based on categorical data in the form of a column chart, however they’re

August 22, 2019

Segmented Survey Data Chart

Charting survey data can be tricky, and when you want a segmented survey data chart it adds another layer of

August 14, 2019

Year on Year Charts

Year on year charts or data over time is one of the most common data visualisations you’ll see. However, the

August 8, 2019

Excel Bar Chart with Vertical Line

In this post I’m going to show you a way to create an Excel bar chart with a vertical line.

May 6, 2019

Include Grand Totals in Pivot Charts

If you work with PivotTables, then you’ve probably found that you can’t include grand totals in Pivot Charts, or subtotals