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.
___________________________________
The comments are working again!
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.
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.
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.
I would use the Waterfall Chart package in my Real Estate business. Many opportunities to show buyer’s and seller’s market trends, etc.
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 🙂