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