Browse by Tags

Daily Dose of Excel

Home

Syndication

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Introducing 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. What should not come as a surprise to anyone who has worked closely with charts and [...] Read More...

Published Fri, Mar 03 2011 6:41 PM by Daily Dose of Excel

Filed under: VBA, Add-ins, Charting, Data Visualization, XLM
TM PivotTable Dashboard

A client wanted to visualize a table of data with a dashboard where each chart represented specific information in the table. I had two choices: 1) Develop a client-specific solution and charge the client the entire development cost, or 2) develop a more general solution, market it to a broader customer base and charge the client [...] Read More...

Published Fri, Jan 01 2011 7:00 AM by Daily Dose of Excel

Filed under: Add-ins, Charting, Pivot Tables, Data Visualization
A Hundred Thousand Name Managers!

Hi folks, Many of the regulars here probably know the Name Manager utility, which Charles Williams and I created and give away for free on our websites. Rumour has it this is one of best tools ever built for the Excel developer. I won’t argue with that! Anyway, as I was looking at my web stats today I [...] Read More...

Published Thu, Aug 08 2010 3:55 AM by Daily Dose of Excel

Filed under: MVP, Downloads, Add-ins, Names
Conditionally Load Excel Add-ins

I currently have 17 add-ins loaded. Can that be right? Let me count again. Yep, seventeen. Six of the add-ins live in C:\Documents and Settings\Dick.NEBRASKA\Application Data\Microsoft\AddIns\, which is the default location for add-ins on my machine. There are a couple that live elsewhere on my local drive. It all [...] Read More...

Published Wed, Jul 07 2009 12:31 PM by Daily Dose of Excel

Filed under: Add-ins
Using LINQ to find and open in Excel 2007 the newest file in a folder

This is one of two approaches inspired by Dick Kuslekia’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/). I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and [...] Read More...

Published Wed, May 05 2009 2:50 AM by Daily Dose of Excel

Filed under: General, Add-ins, User Interface, Fluent UI, .Net

Browse by Tags

Syndication

Recent Posts

Tags

News

Archives

Introducing TM Chart Leader Lines

TM PivotTable Dashboard

A Hundred Thousand Name Managers!

Conditionally Load Excel Add-ins

Using LINQ to find and open in Excel 2007 the newest file in a folder