
Plotly box plots
A very happy discovery today – Plotly, a collaborative data analysis and graphing tool. Looking at the pricing plans the free plan allows for 10 private files to be saved but unlimited public files; Plotly is free for educational use.
Plotly looks very sophisticated with many options and is certainly something I will return to in future posts as I find out more. The images here show the different types of charts which can be created.
I was initially particularly interested in box plots as although they can be created in Excel it takes a bit of fiddling around to do so. With Plotly, simply upload your data or copy and paste it in and there are your box plots! Note the outliers shown clearly. Hovering over a plot displays the data.

Plotly Help
To create the box plots illustrated here I initially started with the Math box plot example from the given examples, chose view data, deleted the given data then copied and pasted my own data (with all three columns in ascending order); I then selected all columns, changed the names to display and chose Box plot.
Choosing Help gives you the choices shown here; the instructions are very clearly set out.
If you want to code yourself, you can; see Plotly’s API Libraries. I will certainly be experimenting further with creating charts in Excel with Plotly.
See the Plotly blog for further information; see this post for example on best fit lines in Plotly or try Contour plots, error bars, chocolate, beer, meat and Facebook for a collection of examples showing the great variety, customisation and sophistication Plotly offers.
An update – Plotly Feed – just admire the beautiful graphs and presentation of information.
You can follow Plotly on Twitter or Facebook. (You do not have to be a Facebook or Twitter user to view these pages).
Update: December 2014 Plotly have put together 11 favourite graphs from 2014
Learn and explore Plotly – there are clear tutorials available on the Plotly site.