My daughter’s got a dentist appointment now, so I’ll try to whip off a quick post while sitting in the waiting room.
While looking up a topic on Charley Kyd’s ExcelUser.com site, I stumbled across his historical article The First Dashboard Used in Spreadsheets. This sample dashboard is so old, it predates Excel*. Charley presented it [...]

No time for a full post today (busy busy!), but I wanted to point you to a well written article by my colleague and fellow Excel MVP Charley Kyd of ExcelUser.com, who explains how to Create Cycle Plots in Excel to Chart Seasonal Sales Data.
If you simply plot date-related data, you may notice cyclical patterns, [...]

I am often asked how to sort the data in a table without sorting the original data. The answer is twofold: the chart’s source data has to be sorted for the charted data to be sorted, but you don’t have to sort the original data if you can write a few formulas. The trick is [...]

Stephen Few of Perceptual Edge is a reknowned expert on data visualization for analysis and communication of quantitative business information. He is the author of Show me the Numbers and Information Dashboard Design, two books that explain techniques which display information effectively, and why these techniques are an improvement over common practices and over the [...]

In the microsoft.public.excel.programming newsgroup, ptheese asked for the following:
I need to chart three groups of two bars on a axis.
-Each group is a year, 2007, 2006, 2005 etc so we can compare data from previous years
-in each group of two there is a profit vertical bar and a combined ratio percentage bar, these [...]

Welcome to the PTS blog. I’m Jon Peltier, host of the blog and owner of Peltier Technical Services. I develop utilities for Excel, dealing with automation and with data processing and display. I have an extensive web site with lots of pages about Excel, particularly charting and programming.
I’ve started this blog so I can show [...]