After weeks of testing and feedback on the Peltier Tech Panel Chart Utility, it was time to implement the bar chart option. It took a day of coding In Excel 2003, a half day of testing and swearing in Excel 2007 (don’t let’s get started on that), and a half day of implementing workarounds for Excel 2007. [...]

Ever make a copy of a chart, and all you want is do is change the worksheet containing the source data? Or change the X values of all series from column A to column B? It sure is a pain to edit each series’ source data range of series formula one by one. The series [...]

Trellis plots (aka panel charts) split plotted data series up into cells of a grid. The resulting small chart invoke the principle of small multiples by using the same axis scales. Putting series into separate mini-charts eliminates the clutter that occurs when too many points are plotted together in the same chart, while still displaying [...]

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

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