cellMatrix.net

Spreadsheet Modeling and Related Topics

A Comprehensive List of Keyboard Shortcuts for Excel

From Pointy Haired Dilbert, a comprehensive list of keyboard shortcuts for Excel.

Posted on Tuesday, February 23, 2010 | Comments (0) | Permalink

Trim and Substitute

A nice post from the Contextures Blog that illustrates how to use the TRIM and SUBSTITUTE functions to clean data for list comparisons, etc.

Posted on Tuesday, February 16, 2010 | Comments (0) | Permalink

Name an Excel Chart with VBA

The code to name an Excel chart using VBA is:

ActiveChart.Parent.Name = "Chart Name"

Posted on Sunday, January 10, 2010 | Comments (0) | Permalink

Build An Excel Add-In Via PTS Blog

Via the PTS Blog - a series of posts that step through the process of building an Excel add-in:


Posted on Tuesday, January 05, 2010 | Comments (0) | Permalink

Chart Enumeration

Key in on the word "enumeration" when searching the Microsoft Knowledge Base for the numbers tied to the VBA chart types.

Posted on Monday, January 04, 2010 | Comments (0) | Permalink

Overview of Built-In Chart Types in Excel

This Microsoft Knowldge Base article describes the types and subtypes of Excel charts. It also describes what type of data each chart best represents.

Reference Article ID: 211951
Posted on Sunday, January 03, 2010 | Comments (0) | Permalink

Trapping Errors Within Excel Macros

This Microsoft Knowledge Base article describes how to trap errors in a macro using various methods.

Reference Article ID: 146864

This Microsoft Knowledge Base article describes how to trap errors in a macro using an "on error" statement.

Reference Article ID: 141571
Posted on Tuesday, December 29, 2009 | Comments (0) | Permalink

Macro to Remove Zero Percent Labels from a Pie Chart

This Microsoft Knowledge Base article illustrates how to use VBA to remove zero percent labels from a pie chart.

Posted on Tuesday, December 22, 2009 | Comments (0) | Permalink

Manipulate Points on a Chart Add-in

Microsoft recently came out with an add-in that allows the user to manipulate points on a chart . . . "In Excel 2007, it's no longer possible to directly change a point a chart. In previous versions, you could drag a chart point to change the underlying value."

via: The Spreadsheet Page

Posted on Tuesday, November 03, 2009 | Comments (0) | Permalink

PTS Waterfall Chart Utility

If you need to graphically represent variances, you probably know that the calculations needed to create waterfall charts that cross the X axis are complex to build and tedious to maintain. The PTS Excel Waterfall Chart Utility is an Excel add-in that automates the process of creating waterfall charts that cross the X axis.

Posted on Sunday, October 25, 2009 | Comments (0) | Permalink

Page 1 of 4 pages  1 2 3 >  Last »

Entries by Day

Mar - 2010
S M T W T F S
28 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 1 2 3