Resources for Excel Virtually Global 2023 session

Thanks for attending my session on some of my Favorite Excel Chart Hacks as part of the Excel Virtually Global 2023 conference. Below are some additional tutorials to learn more about creating advanced charts in Excel and annotating them without using shapes or text boxes.

My full video on forcing a chart to start at zero: https://youtu.be/7MQoLnbiK-w

Using invisible segments to create multiple diverging bar charts from a single stacked bar chart: https://youtu.be/CF3Q32GUeOk

Using #N/A values for conditional formatting of one column in a column chart: https://youtu.be/amwaxp2YkbA

Full CAGR line tutorial: https://youtu.be/iXlb-8DNWpA

Adding a goal line to a bar chart using a scatter plot line: https://youtu.be/bxsb45q5dSM

Adding custom labels to a column chart: https://youtu.be/jqA5BUbgAFM

Adding custom labels to a bar chart: https://youtu.be/7S0ORBrDy7I

Show Min, Max, and Scores for multiple criteria (uses a number of the hacks shown): https://youtu.be/6TcB2PITOrg

To get more ideas for visuals that communicate financial analysis or results, check out these examples.

To arrange for a custom FinancialViz training course for your team where you can dramatically improve the visuals you create for financial analysis and results, learn more here and then send me an email so we can start the planning.

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.

By 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.

View all of Dave Paradi's posts.