Excel Charting Utility Giveaway

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:

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.


You may also like...

41 Responses

  1. Debra says:

    The comments are working again!

  2. Vitalie says:

    I’d use the cluster stack function the most, probably, as I often need this kind of charts in my equity research reports when doing income statement analysis.

  3. Trouttrap2 says:

    I would use the box-plot and Create Nice Table Style the most. I work with water quality data and the need to visualize data is a must.

  4. Tony says:

    I would use the Box Plot, as I used to have this when I was a winner in the “You know you’re an Excel nerd….” competition, but lost it when I upgraded to Office 2013.

  5. Arvid Martin says:

    I would use the Waterfall Chart package in my Real Estate business. Many opportunities to show buyer’s and seller’s market trends, etc.

  6. LollyShu says:

    I try to track various things for our end users, and especially various utility charges. I think a waterfall chart would be the best graphic conveyer of the fluctuating usage, and I’d love to try to create one that not only compares each month but also same month year over year to highlight aberrations.

    Thank you for the opportunity to enter for the winning chance :-)

  7. Vasim says:

    Definitely Cluster Stack and Box Plot

  8. Rudi says:

    I would find the option to export the chart as an image file very handy. I do a lot of presentations and often need a static chart on the slides. This feature will allow me to export a charts easily and later add them to the presentation when designing it. Another option I would find useful is the Quick XY Chart although its the labeling of the chart that is important. I’m not sure if Jon’s add-in includes the labeling, but I’m sure the feature will be great.


  9. Patrick says:

    I’d certainly use the waterfall chart and boxplot utilities the most. I know how to create them manually, but that process is a real pain in the backside if you have to do it often. I would love to have a tool to simplify this!

  10. jimmm says:

    Box plots. We use them all the time as we analyze assessment-to-sales ratios by neighborhood under multiple scenarios. Very, very useful! It would save us from using our stats package and being faced with “inflexible” box plots.

  11. Krystal says:

    The waterfall chart would be very handy in both my work and personal budget. Thanks for the wonderful tips on the site/blog and the giveaway!

  12. Paul S says:

    Just getting into doing more charting. Not sure which I would use the most – perhaps just the quick XY Chart. The extra charting tools look like they could be a definite help too.

  13. Sean says:

    I would use the create nice table style the most. I work a lot with tables in Excel and can never get exactly what I want.

  14. Dan says:

    The Waterfall Chart is absolutely perfect for variance analysis between budgeted items and actual items. I’ve spent a bit of time following Jon’s instructions for creating one but I haven’t mastered it; if I had it, I would have to do less thinking and more working.

  15. Rick McQueen says:

    I would probably use the chart tools the most, to automate the tedious work of manually creating the waterfall and box-plot types of charts.

  16. SimonH says:

    Cluster stack to define movement by customer segment by period.

  17. Maxim Manuel says:

    I will use this add-in to amaze myself and the colleagues in my workplace.

    PS: I see that Debra has posted first. Does she hope winning the prize too? Lol

    Good luck to all!

  18. Rich Halecki says:

    The waterfall chart is really interesting. I chart revenue and expenses for a variety of products. Using it will make the “story” so much easier to tell than the bar charts I was using.

  19. Leonid says:

    I will use Dot plot chart and Export as image feature

  20. Mike Adamson says:

    I would definitely use the “Export Chart as Image File” feature as I currently use Paint as an intermediary.

  21. Jorge Rodríguez says:

    My boss is always asking for new ways to see data. I would definitely use every chart type… mainly waterfalls.

  22. Paul Mason says:

    Definitely the waterfall chart. Totally awesome utility that will save loads of time. Well done Jon !! (and Debra of course!!)

  23. Abhijeet Ghosh says:

    A waterfall chart in a just a couple of keyboard clicks…..That’s awesome…I’ll definitely use that. Not to mention Cluster Stack and Box Plot will be extremely useful for me too. Amazing tool. Great job to the creators.

  24. Lori says:

    Cluster stack utility, quickly see performance by region, products, etc.

  25. Brian says:

    I would most likely try to find an application for each distinct utility, but the main one that comes to mind is the waterfall chart. I currently create manual charts to “bridge” the gap between actual and plan activity on a monthly basis. I’m sure this utility would greatly simplify the process.

  26. Leslie says:

    Installed on my own PC I would use the waterfall chart the most and get away from the dependency of a shared corporate licence for Thinkcell!

  27. Dave says:

    I’d use the waterfalls most for tracking stock incoming, outgoing, sold, brought, total etc which is something i already have to do for monthly reports but this would save me quite a bit of time and finally allow me to get rid of the cheat tab i have to include as a template to build it from

  28. Niyaz says:

    Waterfall and Boxplot…

  29. JeanMarc says:

    I would definitely be using BoxPlot

  30. Mário says:

    The waterfall chart. The best graphic to analyse variances to a target.

  31. Hugo says:

    I’d like to use the Waterfall Chart.

  32. Raju says:

    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”


  33. VaraK says:

    I would use all the options in the utility but Waterfall chart the most..

  34. Clay Hansen says:

    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.

  35. William says:

    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.

  36. Jordan G says:

    I would use the box plot because it’s one of my favorites – and I love the clean lines and aesthetics chosen by Jon

  37. Thanks! The deadline has passed, and I’ll announce the winner tomorrow, August 6th.

  1. August 20, 2013

    […] a consolation to those who didn't win his Charting Utility in the recent giveaway, Jon Peltier gave me a coupon code that you can use to buy the Chart Utility at a 15% […]

Leave a Reply

Your email address will not be published. Required fields are marked *