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

May 18, 2016

Parts to a Whole Excel Charts

For many people when they think of a chart that shows parts to a whole, a pie chart is the

May 10, 2016

Interactive Excel Charts

Using interactive Excel charts in your dashboards and reports allows the user to pick and choose what they want to

February 23, 2016

Excel Alternatives to Radar Charts

I get the fanfare around infographics. They’re used to make information more appealing, grab attention, awaken interest, lessen boredom and

December 8, 2015

Creating Excel Charts from Multiple PivotTables

In an ideal world our data will be in one table so we can easily analyse it in a PivotTable

October 13, 2015

Excel Slicer Trick

That’s a rubbish title, I know. I couldn’t think of a succinct way to describe what I’m about to show

September 15, 2015

New Charts in Excel 2016

With Office 2016 officially launching on September 22, 2015 I thought I’d give you a sneak peek at a few

July 23, 2015

Excel Sparklines

Put some spark in your chart! Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend

April 14, 2015

Excel Chart Vertical Axis Text Labels

In this tutorial we’re going to look at how we can twist Excel’s arm into putting text labels on the

April 1, 2015

Charting Variances in Excel

In my previous life as an accountant one of my main tasks was to analyse budget vs actual variances and

March 24, 2015

Excel Quick Analysis

A new feature in Excel 2013 is called Quick Analysis – it’s data analysis made easy, so easy my 6

January 28, 2015

Skip Dates in Excel Chart Axis

In this tutorial we're going to look at how we can skip dates in the Excel chart axis for those

January 5, 2015

Excel Custom Chart Labels

Using Excel custom chart labels is a great way to create a more insightful chart without having to show a

October 13, 2014

Excel Chart Makeover

Getting the formatting in your chart right can make the difference between clear, concise information and just a pretty picture.

July 22, 2014

Fix Excel Chart Axis with a Ghost Series

Below is a set of Panel Charts. In this case they’re actually 4 separate charts aligned close together. Comparing one

July 15, 2014

3 Steps to Easy Bullet Graphs in Excel

Bullet graphs were developed by data visualisation expert Stephen Few to address the need for visually rich displays of data

June 16, 2014

Plot Excel Data on a Map

If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet.

May 6, 2014

Is Your Line Chart Lying?

Charts are great at revealing trends, patterns and relationships in your data. We love how they enable us to glean

April 22, 2014

Excel Chart Templates

If you find yourself repeatedly spending a few minutes customising your chart colours, formatting the title, legend, axis labels etc.

March 12, 2014

Excel 3D Financial Reports

Last week I wrote about how I used Excel to design a Minecraft cake. The response to that post was

January 23, 2014

Charting Disparate Data in Excel – 3 Solutions and 1 Crazy Mess

Last week we looked at some different ways to plot the same data, with each chart enabling the reader to

January 15, 2014

4 Charts – Same Data. Which do you think is best?

Often when you’re charting data it can be tricky to find the best chart for the job. If you get

October 16, 2013

30 Chants for Better Excel Charts

I see the same innocent mistakes with Excel charts and data presentation over and over again. And a lot of

August 7, 2013

Excel Quintile Chart

One of my Excel Dashboard course members, Mark Maher, emailed me wanting to know if a chart that Stephen Few

July 2, 2013

Interactive Excel Chart with Map

Today I’d like to share with you a video tutorial by Isaac Gottlieb on supply-chain decision making from his book

May 28, 2013

Excel Conditional Formatting Gantt Chart

Gantt charts are handy for planning and managing project tasks over time. They give a visual representation of the whole

May 22, 2013

Excel Gantt Chart

Gantt charts are commonly used in project management and while Excel doesn’t have a native Gantt chart in its chart

April 25, 2013

Excel Step Charts

I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we

March 13, 2013

World’s Most Accurate Pie Chart

As fun as this chart is, it actually makes a valid point and that is; pie charts are (typically) not

October 25, 2011

Top 5 Mistakes With Reports in Excel

There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some

August 17, 2011

Create a Pivot Table Direct From Access

Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data