Browsing the blog archives for October, 2007
Keywords: Excel, custom labels, XY plot chart, scatter plot, macro
Version: Tested on Excel 2003 and Excel 2007
Download:
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 [...]
Popularity: 19% [?]
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 [...]
Popularity: 19% [?]
Keywords: Boxplot, box plot, stem and leaf plots, Excel 2007, how to make
Version: Excel 2007
Dowload:
Since the previous entriesI 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 [...]
Popularity: 100% [?]
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
Possibility to have data in rows or columns
Selectable chart color
Optional x-axis
Option to display [...]
Popularity: 14% [?]
Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel
Version: Tested on Excel 2003
Download: NanoCharts demo (downloaded 1479 times)
Sparklines, or Micro charts, a concept invented by graphic design guru Edward Tufte , compress large amounts of data into intense, word-sized graphics, like for example:
Popularity: 11% [?]
Popularity: 11% [?]
