On my web site I wrote a tutorial that showed how to Label the Last Point in an Excel Chart’s Series, and I posted a small add-in with the labeling procedure. I later blogged about this technique in Label Each Series in a Chart. When Excel 2007 came around, I discovered that the code [...]

The family of PTS Excel Charting Utilities has welcomed a new member: The PTS Cascade Chart Utility. Many customers of other utilities have asked about this type of chart, and I have answered with a new program. A cascade chart shows one value vertically (e.g., revenue) against a cumulative value horizontally (e.g., market segment size).

I talked about LOESS smoothing in LOESS Smoothing in Excel, where I showed my improved VBA function for calculating smoothed data. I introduced an improved LOESS Smoothing utility in LOESS Utility for Excel. Since I use the utility frequently, I encountered many things about it that I wanted to change. Since I am the developer [...]

I described an alternative linear regression approach in Deming Regression. Whereas the standard linear regression techniques assume that all measurement error in the calculated model is in the dependent variable Y, the Deming Regression technique considers that both X and Y variable measurements may contain errors. Pairs of X-Y coordinates are used to estimate the [...]

Peltier Technical Services Inc is pleased to introduce the newest member of its suite of charting add-ins for Excel. The PTS Dot Plot Utility is based on the protocol in the Dot Plots tutorial on this web site, but it does all of the required calculations and chart manipulations automatically.
The Dot Plot Utility makes quick [...]

In LOESS Smoothing in Excel I described a technique for smoothing data, which essentially runs a moving weighted regression on the data set. The amount of smoothing that can be achieved without washing out the data is remarkable. In that post I showed a screen shot of a dialog of a working LOESS utility.
The LOESS [...]

Last fall I released my Box and Whisker Chart Utility, which fills a need for such a chart in Excel. It’s been somewhat popular, and after some frantic bug fixing the first week or so, there have been no further bug reports. There was one design decision I made early on which was not satisfactory [...]

BonaVista Systems, the makers of the MicroCharts family of sparkline and dashboard utilities for Microsoft Excel, has released a new product called Chart Tamer. Chart Tamer is designed to simplify and beautify Excel charts. Actually, I should not say “beautify”, because that implies embellishment. Chart Tamer simplifies and clarifies Excel charts.

A peek at the Chart [...]

I recently wrote a tutorial showing how to create Marimekko Charts in Excel. Like a lot of the chart types I write about, the Marimekko requires a substantial amount of data engineering. Face it, these charts are tedious to build manually.

In order to reduce the tedium of manually rearranging the data and then manually constructing [...]

As my regular readers know, I’ve started building Excel charting utilities. It’s challenging and rewarding, though I certainly won’t retire to my own island in the Caribbean on these utilities alone. Over the past few months I’ve released commercial utilities that create charts that Excel users only used to dream of, such as Waterfall Charts, [...]