Recently I presented a session at the Excel Virtually Global conference on five of my favorite Excel chart hacks. I separated the content into five videos, one for each hack. In each video below, I share the hack as I presented it during the conference session, then I share some additional tips or resources to…
Category: Data & Graphs
Excel Dataviz Tutorial: Show Max, Min, & Scores for multiple criteria
I created this visual based on a request from a student in the Master of Finance program at Queens University. They asked how to visually show the scores on multiple criteria for the organizations they were analyzing. I created a bar chart for each criteria that shows the score, how far it was from the…
Slide makeovers for non-financial metrics
If you work for a government affiliated agency you do not report profit-focused metrics because profit is not your objective. You report on metrics that are important to your organization but are often not financial in nature. You have goals or targets to meet and you measure progress against them. In this article I want…
Excel Chart Hack: Put data series labels in the bars of a bar chart instead of the legend
In a previous video (https://youtu.be/jqA5BUbgAFM) I showed how to replace the legend in a column chart with labels added using a scatter chart. Someone asked if this could also be done for a bar chart. This video shows you how. It is a slightly different approach because the scatter plot has to be placed on…
Create a graph in PowerPoint using data and formulas from Excel for increased functionality
Using the default copy and paste for an Excel graph into PowerPoint results in a link back to the Excel file. If that file is on a drive you can’t access, you can’t edit the graph. If you use the Embed workbook option when pasting the graph into PowerPoint you make the PowerPoint file large,…
Cool effect for presenting Excel column charts/graphs in PowerPoint | Morph alternative hack
Morph, the great PowerPoint feature that you can use with images, shapes, and text to create effects that look like a professional video is not available for charts. Charts are much more complex and Morph isn’t able to figure out where all the different elements should move. This video will show you a cool effect…
Go beyond the basic Excel charts to impress recruiters in a job interview presentation
If you’ve recently been laid off and want to impress a recruiter or hiring manager with an effective data visual, you will want to consider going beyond the basic Excel charts that they will see from everyone else. What you show in a job interview presentation will demonstrate how effective you can communicate analysis to…
Here’s how to start creating graphs in Excel to visualize data for a job interview presentation
It doesn’t matter whether you and your team delivered good results, sometimes a cutback in staff can result in you being let go. If that’s happened to you recently you want to be prepared to show potential employers the positive impact you made at your last job. Data on key metrics is one of the…
Use graphs instead of tables of numbers in a job interview presentation
You and your team have delivered good results over the last few years. But due to financial uncertainty, you have been let go. Your upcoming job interview includes a short presentation where they want you to show how you can improve the results at their company. You have the numbers to prove what you and…
Use this hack to add the data series names in the columns of a graph instead of using a legend in Excel
When you are using a clustered column graph in Excel that has two or more data series, how do you tell the viewer which set of columns is which data series? The default method is to use colors and the legend. This video shows you a way to add the data series names into one…