Some time ago I announced a mini-project called NanoCharts, which is an implementation of Edward Tuftes Sparklines concept. Sparklines (and NanoCharts) are basically small, word sized graphics for high density visualization of data. I have been working to make available a sort of beta release of what will eventually be an Add-in for Excel. At present I have a working version that allow the user to insert some different NanoChart types and do some simple formatting selections. The current user form looks like this:
Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function to insert custom labels; the only options available are Series names, x- and y-values which often are totally inappropriate. I created a workbook with a macro that allows the user to insert the X and Y data along with the desired lables and create a labled scatter plot with the click of a button. See image below.
Tutor Vista stands for a revolution in tutoring. Now students have the opportunity to get online tutoring from highly qualified tutors 24/7, in almost any subject, such as Math, Chemistry, Physics, Biology and so on.
For a set monthly fee (currently there is an introduction offer of $49.99 the first month) the student will get unlimited tutoring in problem subjects to improve grades. The tutors at Tutor Vista are all going thorough a rigorous review process and a comprehensive training before getting assigned any students. This guarantees a high tutoring standard and tutor qualifications ranges from retired professors, to PhD and professionals with Master degrees.
Keywords:Boxplot, box plot, stem and leaf plots, Excel 2007, how to make
Version: Excel 2007
Dowload:
Since the previousentriesI have recieved quite a few questions about Box-plots in Excel 2007, so I decided I should describe one way to create decent looking box plots in Excel 2007. In my example I start with a set of data containing six samples with ten replicates each, and from this I want to create a box plot showing the extremes, median and the quartiles.
As I decided to develop the NanoCharts (a concept more known as Microcharts or Sparklines) into an Excel add-in I’ve started by specifying features and functionality and came up with the following list:
Three different types of charts; bar, line and dot
