Last week, you had a chance to win John Walkenbach’s new book – 101 Excel 2013 Tips, Tricks & Timesavers, thanks to Katie Mohr at Wiley. Thanks for all your comments – those were great tips!
And the winning entry, chosen in a random draw, in Excel, of course, is:
- Neil, with comment 22.
Congratulations Neil! After Katie sends an email to Neil, he has 24 hours to claim the prize. If not claimed, we’ll go to the next name in the randomly sorted list.
This Week’s Giveaway – Excel Chart Utility
This week, you’ll have a chance to win Jon Peltier’s time-saving and feature-packed Excel Chart Utility, which includes a Waterfall chart builder, along with 7 other custom chart types. If you build charts, this tool can save you countless hours.

For example, to build a Waterfall chart, you just select your data, click the Waterfall Chart command on the Ribbon, set a few options, and click OK, and your waterfall chart is ready. It even works if the total values are negative, as you can see in the example below.

Charting Tools and More
In addition to the 8 custom charts, there are 6 useful charting tools.

There is a data tool too, and 3 general tools, to make your Excel work easier.

You can see how well the Excel Waterfall Chart builder works, in this short video.
Enter the Giveaway
Jon Peltier has kindly provided a copy of his Excel Chart Utility for this giveaway. If you’d like a chance to win this awesome add-in, make a comment below.
- In your comment, tell us which of the utility’s features you’d use most often, and why.
- Include your email address, so Jon or I can contact you if you win. Your contact information won’t be publicly visible, and it won’t be used for any other mailings.
- NOTE: Deadline is extended to Monday, August 5th at 12 noon, Eastern time. (PREVIOUS DATE: The deadline is Wednesday, July 31, 2013, at 12 noon Eastern Daylight Time.)
- One entry per person.
- NOTE: Winner will be announced on Tuesday, August 6th. (PREVIOUS DATE: The winner will be selected in a random draw, and announced here on Thursday, August 1st.)
- The winner will have 24 hours to claim the prize, and if not claimed, another name will be selected.
NOTE: Because there were problems with the comments, the deadline is extended to Monday, August 5th at 12 noon, Eastern Time. The winner will be announced on Tuesday, August 6th.
___________________________________
I’d like to use the Waterfall Chart.
I would use the data tool the most a it will be required for my daily use.
I would use the waterfall charting selectively where I have to create an impression and people will most certainly say “Wow how did you do it”
raju
I would use all the options in the utility but Waterfall chart the most..
It is an easy answer because it is showcased here already, but probably the Waterfall utility. I already make those quite a bit…and anything to make them easier would be great.
I discovered the Jon Peltier’s website two years ago. And I love the charting techniques teach in the site.
Particularly, XY Chart with the quick label function is the most useful tool for my daily works which very often requires me to plot the scatter chart for some regression results.
I would use the box plot because it’s one of my favorites – and I love the clean lines and aesthetics chosen by Jon