| Topic | When |
| Removing Spaces from File Names | 1 day, 15 hours ago |
| Arrays to Calculate Consistent Increases in Rate Spreads | 6 days, 11 hours ago |
| Manipulate Points on a Chart Add-in | 2 weeks, 3 days ago |
| Show Gridlines when Filling an Interior Range | 3 weeks, 1 day ago |
| Delete All Embedded Charts from a Workbook | 3 weeks, 1 day ago |
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
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.
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 . . .
