Recently I presented a session at the Excel Virtually Global conference on five of my favorite Excel chart hacks. I separated the content into five videos, one for each hack. In each video below, I share the hack as I presented it during the conference session, then I share some additional tips or resources to help you apply this hack to your own Excel Charts. I have a playlist of all five hacks at: https://www.youtube.com/playlist?list=PL-IegdC89jX-VlgPXhn_8nEvBl3fwg9tV.
EVG 2023 Excel Chart Hack #1: Force a chart to start at zero
EVG 2023 Excel Chart Hack #2: Invisible segments to position visible segments
EVG 2023 Excel Chart Hack #3: Use #N/A to hide a data point
EVG 2023 Excel Chart Hack #4: Add a custom line to a chart
EVG 2023 Excel Chart Hack #5: Add a custom text box
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.