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…
Author: Dave Paradi
Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.
5 Tips for handling the increased financial reporting workload after colleagues get laid off
We are in another round of layoffs in many organizations. This time it is a slowing economy due to rising interest rates. In the past it has been different factors and the result is the same: fewer financial professionals doing the same (or more) work every month. Here are five tips to get those monthly…
How to use a single Excel stacked bar chart for multiple diverging bar charts to report variance (planning a complex chart in Excel)
One of the visuals I show in my FinancialViz courses is a multiple diverging bar chart that can show variance between actual and budget and actual and last year. This can also be used for actual and relative variances as well. I create it using a stacked bar chart and scatter with straight lines charts.…
Hybrid Event Lesson 10: Introduce the remote attendees to the people in the room
This article shares one of the lessons I learned when planning and running a hybrid class reunion event in May 2022. Read the introduction and see the other lessons in this series here. Lesson One of the issues with hybrid meetings is how to build a connection between the people in the room and those…
Hybrid Event Lesson 9: Have multiple cameras for views of the room and the presenter
This article shares one of the lessons I learned when planning and running a hybrid class reunion event in May 2022. Read the introduction and see the other lessons in this series here. Lesson One of the issues I identified early in planning for the hybrid reunion event was that I wanted the people attending…
Excel Chart Tip: Add a goal or target line to a bar chart
When you are showing ranked data in a bar chart you may want to add a goal or target line to easily identify those with performance above the goal and those below the goal. Instead of drawing the line on top of the chart, build the target or goal line as part of the chart…
Hybrid Event Lesson 8: Separate content and meeting control
This article shares one of the lessons I learned when planning and running a hybrid class reunion event in May 2022. Read the introduction and see the other lessons in this series here. Lesson In the event I was running each laptop only had its own screen, I didn’t have any extra monitors connected to…
Hybrid Event Lesson 7: Create a custom screen background
This article shares one of the lessons I learned when planning and running a hybrid class reunion event in May 2022. Read the introduction and see the other lessons in this series here. Lesson When you are switching content in a hybrid meeting the screen may sometimes not have an open app on it. What…
Excel Chart Tip: Add a CAGR line callout to a column chart
When you are reporting sales, shipments, clients served, or any measure where you want to show the growth rate over the period of time along with the values in each period, a column chart with a CAGR line callout can be a good visual to use. Instead of drawing the line on the chart and…
Which Logitech webcam camera software app should you use for Windows & Mac
Logitech webcam cameras are probably the most popular type of external webcam in use. If you want some advice on which one to buy for Zoom and Teams business meetings, I wrote a detailed review of the different criteria you should use and what I recommend. If you don’t want to read the details and…