In this video I show how to add a breakeven line to a line graph to show when the values change from negative to positive. You can adapt the technique in this video to other situations of values passing a criteria over time.
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.
Add/Insert an Excel chart/graph on a PowerPoint slide
If you are using an Excel chart in a presentation, you will want to insert or add the chart to one of your PowerPoint slides. There are a number of ways you can do this. I recommend four methods, two where the graph in PowerPoint is not linked to the Excel worksheet and two where…
Conditional formatting for donut chart
Jon Acampora of Excel Campus has created two videos on creating a donut chart that has conditional formatting so that the segment that represents progress changes color based on the percentage value. The first video goes over the basic steps to create a donut chart. The second video extends this to add conditional formatting to…
TrainingMagNetwork Webinar September 9, 2020
On September 9, 2020 at 9:00 am Pacific/11:00 am Central/Noon Eastern Dave will present a session titled PowerPoint Visuals to Use When Presenting to Executives. Click here to learn more and register.
How to choose the right chart in Excel
How do you choose the right chart to report results or analysis? Don’t select a chart or graph just because it looks cool or pretty. In this video I share the two big issues with putting spreadsheets on slides, the three reasons business professionals put spreadsheets on slides, and introduce a structured way to identify…
Get started creating a chart in Excel
Never created a chart in Excel and want to learn the basics? Start with this article and video (also below) by Excel MVP Leila Gharani. Have an Excel chart you or someone else created and you want to copy it so you can use the same formatting with different data? Here’s how to do that from Excel MVP Jon…
Virtual sessions for technology company (September 9-24, 2020)
Delivering eight 90-minute sessions (equivalent to a two-day workshop) covering how to structure content, reduce information overload, select the right visuals, present in a virtual setting, and the Excel and PowerPoint techniques to create effective visuals. Delivered over Zoom.
How to create an Excel chart with a dynamic range that you select
Basic dynamic charts A standard chart in Excel uses a defined set of cells for the category axis and the data values. This works for most charts. But what if you want to create a chart where the data range gets bigger or smaller based on criteria? That is where you will want to create…
Free training videos; Issue #447 September 3 2019
In our neighborhood the kids are heading back to school today. This often makes the rest of us think about upgrading our skills so today I want to highlight some free playlist s of videos I have on my YouTube channel that can help you make your presentations more effective. To get notified of new…
The Globe and Mail August 29, 2019
Suggestions from Dave’s article on using big data tool dashboards to replace executive reporting were included in Harvey Schachter’s online Power Points column on August 29, 2019.