cellMatrix.net

Spreadsheet Modeling and Related Topics

Welcome to cellMatrix.net

cellMatrix.net features examples of formulas, charts, and models created with Microsoft Excel. A special interest is placed on the use of VBA for improving processes and the embedded chart object model.

Latest Blog Entries

- Excel 2010 Chart Improvements - Migrating Excel 4 Macros to VBA
- VBA Array to Change Line Chart Colors
- VBA Function to Screen for Certain Charts
- VBA for Adding and Deleting Data Labels
- Delete All Embedded Charts from a Workbook

image
Charts

Interesting articles related to charts:
- Breakeven Chart with Dynamic Label
- Healthcare Waterfall Chart
- A Study of Pie Chart Rounding

image
Models

Designed with a spin on Heathcare, these models might interest you:
- Calculating Consistent Rate Spreads
- Arrays to Calculate Consistent Increases in Rate Spreads

image
Tools

The Formula Trace Tool is designed to make the process of auditing of an Excel spreadsheet, workbook, or series of linked workbooks much easier. Read more . . .