New and Improved
Announcing the new and improved Peltier Tech Chart Add-Ins for Microsoft Excel. They were pretty good to begin with, but there have been some changes. I’ve updated all of the add-ins, plus tested them in umpteen versions and languages of Excel, repackaged them, and uploaded them.
If you have purchased one of these add-ins [...]

My posting has been light for a week or so because I’ve been upgrading my commercial charting utilities. The most important upgrade has to do with RefEdit controls.
RefEdit Problems
I’ve written here about Using RefEdit Controls in Excel Dialogs, and I use them a lot because they come in handy when the user has to identify [...]

Last fall in LOESS Utility – Awesome Update I introduced the latest version of my LOESS Utility for Excel. Compared to the earlier version, this one provides the user with much more flexibility in data range selection. As with all of my utilities, I made these adjustments after using the utility for my own real [...]

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 [...]