Excel Charting Utility Giveaway

Excel Charting Utility

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.

waterfallchartutility01

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.

waterfallchartutility03

Charting Tools and More

In addition to the 8 custom charts, there are 6 useful charting tools.

peltiertechchartutility02

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

peltiertechchartutility03

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.

___________________________________

41 thoughts on “Excel Charting Utility Giveaway”

  1. 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.

  2. 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.

  3. 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.

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

  5. 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 🙂

  6. 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.
    TX

  7. 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!

  8. 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.

  9. 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!

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. 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!

  15. 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.

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

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

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

  19. 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.

  20. 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.

  21. 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!

  22. 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

  23. 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

  24. 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.

  25. 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.

Comments are closed.