Excel Charts Archives • Page 2 of 4 • My Online Training Hub

January 30, 2019

Excel Five Star Rating Chart

Creating an Excel five star rating chart is easy with Conditional Formatting. They’re not limited to stars, you can also

November 15, 2018

Excel Power Query Pivot Chart

The options in the Pivot Chart library are limited, which you’ll know if you’ve ever tried to create a Scatter

November 8, 2018

Excel Scatter Pivot Chart

Ok, that title is a lie. There’s no such thing as an Excel Scatter Pivot Chart. It’s like mixing water

November 1, 2018

Excel Line Charts vs Dot Plot

A common chart mistake is to use a line chart for the wrong type of data. An example of that

August 21, 2018

Excel Chart Titles

Excel Chart titles are often a wasted opportunity to connect with your audience and drive home your message. So, let’s

August 14, 2018

Excel Analyze Data

Understanding your data and creating Excel charts has never been easier with Excel's Analyze Data (previously known as Excel Ideas

August 8, 2018

Excel Waterfall Charts

Excel Waterfall charts are now available to Office 365 users via the Insert > Charts menu. It makes light work

August 2, 2018

Real Time Data Add-In for Excel

Last week I looked at getting real time data into Power BI using PubNub. This week I want to take

May 16, 2018

Excel Mini Charts

Excel mini charts are a great alternative to Sparklines. Mini charts are just regular charts made really small. You might

May 8, 2018

Excel Multi-colored Line Charts

Excel multi-colored line charts are a little gimmicky, after all we don’t need color to tell if a line is

May 3, 2018

Excel 3D Maps

Excel 3D Maps in 2016, or Power Map as it’s known in Excel 2013, enable you to visualise data in,

February 14, 2018

Excel Infographics

Excel infographics, like the one below, are easy to build and there are loads of tools you can use to

February 5, 2018

Excel Forecast Sheet

The Excel Forecast Sheet and charts are a new feature available in Excel 2016. In just a few clicks you

January 31, 2018

Labelling Events in Excel Charts

Plotting data over time can reveal patterns and trends, but often blips in the data require further explanation. We can

December 14, 2017

Excel Chart Formatting Tips

Format your dashboards and reports fast with these pro Excel chart formatting tips. Watch the Video Pro Tip 1 –

December 6, 2017

Excel Dot Plot Charts

Dumbbells and Lollipop Charts Excel Dot Plots, dumbbells and lollipop charts are good for comparing one, two or three points

November 30, 2017

Visualizing Parts to a Whole in Excel Charts

When you think of visualizing parts to a whole in Excel charts the first thing that’s likely to come to

November 17, 2017

Plot an Equation in Excel Using Python

Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x +

October 2, 2017

Label Excel Chart Min and Max

Highlighting the minimum and maximum in an Excel chart can help focus your readers’ attention. We can manually select points

September 26, 2017

Dynamically Label Excel Chart Series Lines

The default Excel chart legends can be awkward and time consuming to read when you have more than 2 series

September 7, 2017

Excel Pivot Chart Drill Down Buttons

Excel Pivot Chart Drill down buttons are a new feature available in Excel 2016. You’ll find them in the bottom

July 5, 2017

Excel Chart Secondary Axis Alternatives

Sometimes a secondary axis is a necessary evil. After all, most of the time you can’t plot big numbers and

June 29, 2017

Excel Chart Highlighting

One of the cool features of Power BI is the ability to cross filter and highlight charts. With a simple

March 16, 2017

Excel Map Charts

New in Excel 2016 (for Office 365 subscription users only*) are Map Charts. *If you have Office 365 and can’t

December 15, 2016

Excel Charts for Surveys

Survey data can be tricky to display in a chart so in this post I’m going to give you some

December 7, 2016

Excel Heat Maps

Excel Heat maps can speed up interpretation of data and focus the reader’s attention to problem or key areas. And

December 1, 2016

Excel Slopegraphs

Slopegraphs were first introduced by Edward Tufte in his book, The visual Display of Quantitative Information (1983) where he referred

August 11, 2016

Slicer Controlled Interactive Excel Charts

Slicers are a great tool for easily filtering PivotTables and Pivot Charts, but what if you want to use a

August 3, 2016

Excel Chart Colors

I was reading a health magazine last week and the chart below caught my eye. click image to enlarge (sorry

July 5, 2016

Create Regular Excel Charts from PivotTables

PivotTables are a great way to summarise your data, but PivotCharts can be a pain in the, um, neck. PivotChart