FinancialViz Makeover: Comparing to an average with long labels; Issue #426 October 30 2018

The latest FinancialViz makeover video I posted illustrates how to create an effective visual when dealing with two situations: first, values are compared to an industry average, and second, the company names are long. The original visual was published in the June 2018 issue of the Globe and Mail Report on Business magazine. This is the…

FinancialViz Makeover: Comparing to an average with long labels

This makeover shows how using a dashed line as part of a graph allows easy comparison of values to an average and a bar chart makes long category labels easier to read. (this is a silent video and you can pause it to spend more time on any of the slides) https://youtu.be/MUjhlbdvqRQ

P2F2 Conference (October 20-23, 2019; Salt Lake City, UT)

At a conference for financial professionals in the pension plan industry I will be delivering a pre-conference workshop on advanced Excel graphing techniques and a concurrent session on how to present financial results and analysis visually. This conference is restricted to association members only and is not open to the public.

Presenting the income or P&L statement: How to highlight the largest revenue segment or expense item

You’ve analyzed the income and expenses and need to communicate important findings to the executives or Board. If you want to focus on the largest revenue segment (product, geographic region, etc. ) or expense item, watch this video to learn how to use a bar chart with color focus to show the data and direct…

FinancialViz Makeover Change in sectors over time; Issue #423 September 18 2018

The latest FinancialViz makeover I posted illustrates a better way to show change in values over time. The original visual was published in the July 2018 issue of the Globe and Mail ROB magazine. Here is the original visual. I selected this visual because it illustrates two issues that lead to audiences misinterpreting the meaning…

FinancialViz Makeover: Change in sectors over time

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)

Getting Designer ideas without Office 365 at work; Issue #422 September 4 2018

Software and services are always looking for ways to improve our work, and PowerPoint is no different. About two years ago PowerPoint introduced a feature called Designer. This feature interprets the content on your slide as you create it and suggests different layouts to improve the look of the slide. Designer suggests a more visual…