I’ve written about Excel chart error bars in Error Bars in Excel Charts for Classic Excel and in Error Bars in Excel 2007 Charts for New Excel. Both articles contained instructions for adding custom error bar values for individual points, but judging from the emails I receive, a separate article on custom error bars is [...]

In Plotting Values Against Limits, I showed a few ways to compare some values (in this case, hourly wages) against recommended limits. In this post I’ll show a Box Plot approach to displaying this same data. The box plot will include the familiar boxes for the inner quartiles and whiskers for the outer quartiles calculated [...]

In a comment to another post, Lynn buttered me up a bit, then asked how to make a certain chart for her boss. Lynn has to plot ten employees’ hourly wages against recommended maximum, minimum, and medium wages. Only four actual wages fall within the recommended limits. I can think of many ways to plot [...]

Last week in Quick Analysis of Web Browser Stats I provided a line chart (“timeline”) to augment Ed Bott’s discussion of Google Chrome’s inroads in the browser market (from Chrome takes a bite out of IE and Firefox). Ed occasionally revisits the relative market share of the different browsers, but it’s not a regular monthly feature. [...]

In Chrome takes a bite out of IE and Firefox, Ed Bott describes how Chrome has started eating into the browser market share of both Internet Explorer and Firefox. Ed’s analysis looks right on, but he was rather light on data visualization. I figured I’d help out with some enhancements to Ed’s data presentation. Ed [...]

In Make a Copied Chart Link to New Data I showed how to copy one sheet with data and a chart, or a data sheet and another sheet with a chart, so that the new chart links to the new data. The protocol is more complicated than you would expect the first time you get [...]