TM Chart Leader Lines

TM Chart Leader Lines simplifies the management of leader lines in a chart. This add-in, which works only with Excel 2007 or later versions of Excel, allows the easy interactive arrangement of data labels and their associated leader lines. For more see

Oct 14th chat with MVPs about Office 2010 and Windows 7

This is a first time event for me so I have no idea of what to expect. I volunteered and Microsoft took me up on my offer to be one of the Excel panelists. The blurb from Microsoft: Would you like to learn more about the cool new features in Office 2010 and Windows 7 …

Continue reading ‘Oct 14th chat with MVPs about Office 2010 and Windows 7’ »

TM Directory Listing

The TM Directory Listing add-in, with over 4,000 downloads in the last 12 months, creates a table in Microsoft Excel of all the files and folders (also known as directories) in a specified directory. Several options control what is shown and it includes the capability of creating a outline. The result is easily extended to …

Continue reading ‘TM Directory Listing’ »

Automatically identify rows with an empty attribute

In a social.answers forum, Sue asked if there was a way to automatically copy rows that had a blank value in a particular column. See As a fan of using SQL, particularly through MS Query, I came up with the following. Suppose we have a table with 3 columns, with a few empty values …

Continue reading ‘Automatically identify rows with an empty attribute’ »

Regular chart version of a sparkline

In one of the web forums (Microsoft’s replacement for the newsgroups no longer hosted on its own server) someone wanted to see a regular chart version of a sparkline when s/he clicked on the cell. I thought that was an interesting idea since one can see much more detail in a large object than …

Continue reading ‘Regular chart version of a sparkline’ »