FinancialViz Category: Comparing Values

This makeover is based on a recent example from a session I delivered at a conference in Philadelphia. I commonly see tables of related metrics in the slides from the participants in my FinancialViz training courses. In this video I show you how to turn the table into 3 visuals, each one based on the… Continue reading FinancialViz Makeover: Table of metrics to 3 visuals based on the message for each metric

This makeover is a recent visual I worked on and is similar to the “Top 5 / Bottom 5” visuals I see in my FinancialViz training courses. In this video I show you how to make the message clearer and it is done only using Excel, what you are already using. If you want to… Continue reading FinancialViz makeover: Make a Top 5 / Bottom 5 bar chart communicate clearly

I see dual-axis graphs frequently in the customized FinancialViz courses that I teach. In this video I show you an alternative to a dual-axis graph that better communicates the message to executives and stakeholders. It is possible to create the type of effective graph you see in this video just using Excel. If you want… Continue reading Dual-axis graph makeover: create a better visual for your data using Excel

Comparing actual spending to budgeted spending is an important topic in many presentations. Too often the actual and budget amounts are shown in a table and the audience is expected to subtract large numbers in order to understand the difference. This makeover demonstrates how you can use a diverging bar chart with explanations to show… Continue reading Comparing actual to budget with explanations; Slide Makeover #95

This makeover shows how using bar charts beside each other makes it easier to compare multiple characteristics of the same items or areas. (this is a silent video and you can pause it to spend more time on any of the slides)

Today you will learn a great visual to use when presenting Assets or Liabilities from the Balance Sheet. Too often Balance Sheet presentations to executives or the Board are filled with spreadsheets. In my surveys of audiences they tell me that large tables of numbers are confusing and overwhelming. Our audiences want meaningful visuals instead… Continue reading Presenting the Balance Sheet: Visually show Assets (or Liabilities) with YoY change

Visually show variances: This Year compared to Last Year and Budget To see how well we are doing this year, we compare this year’s results to last year’s results and to the budget we set at the start of the year. Too often we show a spreadsheet of the numbers and expect the audience to… Continue reading Showing difference between this year and last year/budget; Slide Makeover #93

You have looked at the difference between the actual and budget expenses in the different expense categories. You want to communicate the variances visually. This video shows how to use a steps to a total column graph to show the actual expenses and variance in each category and how they add to the total expense… Continue reading Presenting the income or P&L statement: Show Budget and variance walk of expense categories

This makeover shows how using color and the right visual helps the audience compare the change in sectors between two time periods. (this is a silent video and you can pause it to spend more time on any of the slides)

I think makeovers of slides or visuals is a great way to see what is possible in our own presentations. If we have never seen a visual used in a certain way before, we would never think of applying it to what we present. The makeovers that I use in my custom workshops are always… Continue reading SWD Challenge September 2018

This makeover shows how using color and position helps the audience compare common elements in two categories or data series.

This makeover shows a way to compare the revenue and profit from multiple lines of business

Use a diverging bar chart to compare two data series that are related

Focus the audience on the comparison of the values in the important segments in a stacked column graph

Focus your message with a visual that highlights important variances

When comparing values, make sure the order supports the message

Use a multiple-width overlapping column graph to compare current performance to past and expected performance

When the difference in values is the message, just show the difference, not the values

Use a trick in a stacked bar chart in Excel or PowerPoint to create a graph that visually shows the range of values.