Posted in Excel on May 27th, 2008 No Comments »
Keywords: histogram, normal distribution, Excel 2007, column chart
Version: Should work with any version. Tested with Excel 2007.
This article contain a quick tutorial on how to create a simple histogram in Excel 2007, to visualize for example student test score, like in the example.
Popularity: 24% [?]Share This
Popularity: 24% [?]
Posted in Excel on May 26th, 2008 No Comments »
Download: QC chart for Excel 2007 / 2003 (downloaded 137 times)
A couple of years ago I created a very simple QC-chart to keep track if instrument performance over periods of time. The chart fetches the usual data from user input and calculates average, upper and lower control and warning limits, and plots these data into […]
Popularity: 19% [?]
Posted in Excel, News on Oct 31st, 2007 No Comments »
Just a short note found on the MS Excel team blog stating that the Microsoft research team has developed an add-in that enables users to browse the web via the add-in and select data to import to Excel, all while the add-in will adapt and learn from your selections.
The system extracts data by learning from a user’s […]
Popularity: 55% [?]
Posted in Excel, Screencasts on Oct 31st, 2007 No Comments »
Excel is known for it’s excessive use of clutter and unnecessary “eye candy” (a.k.a as chart junk) in their default chart types. However, you can correct this with a few clicks to produce nice looking charts with at least less distracting layout. Have a look at this screencast for a quick walk-through on how to clean […]
Popularity: 31% [?]
Posted in Excel, DevLog on Oct 26th, 2007 6 Comments »
Keywords: Nanocharts, sparklines, VBA, in-cell graphing
Version: Tested on Excel 2003.
Download: NanoCharts public beta 0.51 (downloaded 548 times)
Popularity: 47% [?]Share This
Join the forum discussion on this post - (1) Posts
Popularity: 47% [?]