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 http://www.tushar-mehta.com/excel/software/chart_leader_lines/index.htm

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 http://social.answers.microsoft.com/Forums/en-US/excslcreate/thread/dd6af3c8-5801-43c0-86f4-a668cdc3fd85 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 social.answers.microsoft.com 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’ »