Indezine Logo




Create a Waterfall Chart in PowerPoint - Part 6

Explore adding leader lines to waterfall charts in PowerPoint.


Author:

Product/Version: PowerPoint





< Continued from Page 5

Another common feature of Waterfall charts is leader lines, or step lines, that connect each value within the Chart (as you can see below in Figure 1). These can easily be added to any Waterfall chart by overlaying a second level of data into the chart.

For this example, I will continue with the same data points and Waterfall chart.

Basic Waterfall Chart with Leader Lines
Figure 1: Basic Waterfall Chart with Leader Lines

  1. Setting Up Leader Lines: To add leader lines, first return to the Excel spreadsheet behind the chart, by right-clicking the chart and selecting the Edit Data in Excel option.
  2. You will then need to add additional columns for the leader lines into the chart area to overlay on top of the chart.
  3. As a hard rule, you always need one less leader line that you have rows of information in your chart. Since I currently have five rows of information in the Chart, I will then need to add four columns of data to my plot area, for a total of four leader lines. I will simply label them L1, L2, L3, and L4 across the top of the Excel sheet within the plot area (see Figure 2, below).
  4. Setting Up the Leader Lines
    Figure 2: Setting Up the Leader Lines
  5. Note: If your chart plot area doesn’t automatically adjust, drag the little plot area icon, the little blue arrow, to cell H6.
  6. Filling in the Leader Line Data: To set up the leader lines, you need to hard code each leader line to start at the Total for that category and continue on one cell below. So two data points for each leader line.
  7. So for example, L1 will start at 40 (the Total for Raw Materials) in cell E2 and end at 40 continue on at the same value, 40 into cell E3. L2 will start at 70 (the Total for Tooling) in F3 and continue on at the same value, 70 into F4, and so on.
  8. Simply hard-code the values in for each leader line, which should create a step like process across your plot area, as shown in Figure 3, below.
  9. Hardcode the values
    Figure 3: Hardcode the values
  10. Returning to PowerPoint: With the leader lines set, hit Ctrl + W on your keyboard to close the Excel spreadsheet and return to PowerPoint, where you will only be able to see one of the new columns (purple in my chart).
  11. Returning to PowerPoint
    Figure 4: Returning to PowerPoint
  12. Changing the Chart Type for the Leader Lines: Right-click a data point in the chart and in the right-click menu select the Change Series Chart Type option to launch the Change Chart Type dialog box.
  13. Here in PowerPoint 2013 for Windows, you should be taken to the new Combo Chart Type. Within the Change Chart Type dialog box you simply want to scroll down and for L1 through L4, change the chart type to a line, which adds colored lines to your chart in the preview window. Then close the Change Chart Type dialog box.
  14. Change Chart Type Dialog Box
    Figure 5: Change Chart Type Dialog Box
  15. Changing the Chart Types
    Figure 6: Changing the Chart Types
  16. Formatting your Lines: From here you can format your lines to fit into your graphic. I typically change the outline color and width to match the column charts, so black outline color and ½pt outline weight. You can also change the lines into solid lines if you like.
  17. Pre-Formatted Lines
    Figure 7: Pre-Formatted Lines
  18. Basic Waterfall Chart with Leader Lines
    Figure 8: Basic Waterfall Chart with Leader Lines

Ending Excel Spreadsheet Formulas for your Negative Waterfall chart with Leader Lines

Just as a reference, below is what the formulas inside the Excel spreadsheet of your negative Waterfall chart look like.

Formulas inside the Excel spreadsheet of your negative Waterfall Chart
Figure 9: Formulas inside the Excel spreadsheet of your negative Waterfall chart


See Also:

Create a Waterfall Chart in PowerPoint - Part 5
Create a Waterfall Chart in PowerPoint - Part 4
Create a Waterfall Chart in PowerPoint - Part 3
Create a Waterfall Chart in PowerPoint - Part 2
Create a Waterfall Chart in PowerPoint - Part 1

You May Also Like: Obama Gets Back on Message - by Jerry Weissman | How to Give a Short Speech at a Celebratory Festive Event


Popular Posts

Create Animated GIFs from PowerPoint Slides
Create Animated GIFs from PowerPoint Slides
Explore ways to create animated GIFs from PowerPoint slides.

PowerPoint Tutorials
PowerPoint Tutorials
These PowerPoint tutorials have many screen shots that show you exactly what you see in your computer!

Use Safe Fonts Available on All Systems in PowerPoint
Use Safe Fonts Available on All Systems in PowerPoint
Learn about using safe fonts in PowerPoint.

10 Tips for Pecha Kucha
10 Tips for Pecha Kucha
Read 10 amazing Pecha Kucha tips that will help you create and deliver a better Pecha Kucha presentation.



Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Create a Waterfall Chart in PowerPoint - Part 6.


Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2021, Geetesh Bajaj. All rights reserved.