There is a free app available for Excel (2013 or Online version), that lets you create 8 different chart types, including some that aren’t standard Excel charts, such as box plots. The app is called XLMiner Data Visualization, and it’s created by Frontline Systems, which also makes the Solver add-in.
If you log in to your Microsoft account, you can download and install the app from the Microsoft Store. Then select data, and the chart appears in the app’s window. In the screen shot below, you can see the box plot chart that I created, in just a few seconds.
The free version of XLMiner lets you do the basics, and if you want more features, you can upgrade to the Pro version. It costs $995, about the same as Tableau Desktop. And if you want quick, fancy charts, at a much lower cost, take a look at Jon Peltier’s charting utility.
Contextures Posts
Here’s what I posted recently:
- Earlier this month, I updated my Data Validation Multi-Select Premium kit, so it’s much easier to customize the code, and add it to your file. If you’ve purchased a copy of the kit, you should have received an email with a link to download the new version. I’ve also created a page with answers to frequently asked questions about the product, and please let me know if you have any other questions.
- Create random text for sample data, with the functions RANDBETWEEN and CHOOSE. There are great suggestions in the comments too.
- Instead of leaving the default headings, you can remove “Sum of” and “Count” from pivot table value field headings. A short video shows the steps.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful:
- How big is that worksheet? Francis Hayes (The Excel Addict) calculated the size in his latest newsletter, and you might be surprised.
- Prof. Lee Townsend shares her code for printing to either the default printer or to a PDF file. She found that the PC version works nicely, but the Excel for Mac version isn’t as cooperative – it will crash if you don’t follow the exact steps that she outlines.
- Maybe there aren’t any bugs in your code, but Andrew Wulf explains the fine art of solving strange bugs, using examples from projects that he’s worked on.
- Mike Alexander helps us understand weighted averages, and reminds us not to take an average of an average.
- With Excel formulas, you can convert numbers to words in English, Italian or Hungarian, using the sample files from The FrankensTeam.
- Previously, Ken Puls shared his favourite Text functions, and now he has posted a Power Query version of that list.
- Scott Lyerly is getting a “multiple selections” error when copying data from one file to another — even if it’s a single cell. Do you have any suggestions for fixing this?
- If you get bored with budgets and financial reports, try making one of the cool Excel projects that Mashable found.
Excel Announcements
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
ModelOff Competition
Registration has opened for this year’s ModelOff competition. Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.
- Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th.
- The Top 16 finalists will compete in New York in December.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
________________________________