Excel Charts

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …