Browsing the archives for the Excel category
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 downloadable example.
Popularity: 42% [?]
Popularity: 42% [?]
Download: QC chart for Excel 2007 / 2003 (downloaded 2602 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: 14% [?]
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 [...]
Popularity: 47% [?]
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: 7% [?]
Keywords: Nanocharts, sparklines, VBA, in-cell graphing
Version: Tested on Excel 2003.
Download: NanoCharts public beta 0.51 (downloaded 1196 times)
Popularity: 12% [?]
Popularity: 12% [?]
