Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Waterfall Chart Utility

by Jon Peltier
Monday, September 1st, 2008
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In Waterfall Charts, Fancy Waterfall Chart, and Waterfall Chart that Crosses the X Axis, I have described techniques for constructing waterfall charts in Excel. I have also written a Waterfall Chart utility that allows the user to construct waterfall charts charts directly from the data. The utility inserts a new worksheet, adds a table with the appropriate data and the necessary formulas, and then creates and formats a waterfall chart from this table. The utility is designed to work in Excel versions 2000, 2002, 2003, and 2007. The utility has not been tested in any Macintosh version or in Excel 97, it may or may not work on these versions.

Features of the PTS Waterfall Chart Utility are shown below.

  • Integrated into Microsoft Excel spreadsheet software as a standard add-in.
  • Create complex charts in a few simple steps using an intuitive wizard.
  • The utility adds a button to the Excel menu or Ribbon.
  • Works in Excel versions 2000, 2002, 2003, and 2007 (Windows versions only).
  • Customize the finished chart with your own colors, fonts, and other formatting.
  • Add data labels above plotted bars.
  • Sort categories by value or label.

The Waterfall Chart dialog is shown below:

Purchase the Professional Utility
The utility can be purchased from the PTS Excel Waterfall Chart Utility page.

Installation and Use of the PTS Waterfall Chart Utility
Instructions for installing and using the utility are found in the PTS Waterfall Chart Utility Documentation page.

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

Comments


Comment from Jørn
Time: Wednesday, September 3, 2008, 11:43 am

I am not able to unzip the demo file :-(


Comment from Jon Peltier
Time: Wednesday, September 3, 2008, 12:02 pm

Jørn -

Occasionally I’ve found that the download ends prematurely, and the zip file is incomplete. Wait a short time, then try downloading it again. If you still encounter problems, email me at the link in the blog post, and I will reply with the zip file attached.


Pingback from DSA Insights » Blog Archive » List of Data Analysis and Visualization Excel Add-Ons and Utilities
Time: Thursday, September 25, 2008, 8:19 am

[...] Waterfall Chart Utility [...]

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.