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:

Using invisible segments to create multiple diverging bar charts from a single stacked bar chart:

Using #N/A values for conditional formatting of one column in a column chart:

Full CAGR line tutorial:

Adding a goal line to a bar chart using a scatter plot line:

Adding custom labels to a column chart:

Adding custom labels to a bar chart:

Show Min, Max, and Scores for multiple criteria (uses a number of the hacks shown):

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.

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.