Browsing the blog archives for September, 2007
Keywords: Excel, box-plot,box plot, median, whiskers, percentile chart.
Version: Excel 97 or later
Due to the popularity of the Box-plot and whiskers chart in Excel article published some time ago I decided to revise the article with a new, improved way of creating box-plot charts containing more information. The approac is slightly [...]
Popularity: 9% [?]
Version: Tested with Excel 2003
Keywords: in-cell graph, in-cell chart, text chart graph
In-cell graphs are built in Excel 2007, but these are notorously hard to read and actually does more to confuse the reciever than anything else. There are an alternative option which is very simple to use. Using the REPT function in excel repeats a [...]
Popularity: 3% [?]
Version: Tested on Excel 2003.
Keywords: Excel, data points, custom images, change default
It is surprisingly easy to change the somewhat boring, default data points in excel to something more of your own taste and imagination. Here’s how to do it:
1. Create some random values and a default line graph.
Popularity: 3% [?]
Popularity: 3% [?]
Summary:This article covers eight important features and considerations to improve usability and the reader confidence for your blog.
This post is largely based on Jacob Nielsens ideas about writing and presenting content on Internet. The focus is on usability, and building a relationship of trust between the user and the author. If you fulfil these two [...]
Popularity: 3% [?]
Internet users, and blog readers, generally don’t like to read long, winding texts, so cut your writing in half. Make sure your content is scannable and properly structured, starting with the conclusion and then the supporting information. I’ve been reading a bit about what makes or breaks a text on the Internet, or more specifically, [...]
Popularity: 3% [?]
