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.
Some formulas in Microsoft Excel return error values under certain conditions. To trap errors under these conditions, the Microsoft Knowldge Base provides the IFERROR Function.
By default, Windows Explorer hides the filename extension from you. To fix this problem in Explorer, open Windows Explorer (My Computer) -> Tools -> Folder Options -> View. Uncheck the "Hide file extensions for known file types" option. Then click "Apply to all folders".
This Microsoft Knowledge Base reference provides a list of keyboard shortcuts for machines running Windows.
This article from the Microsoft Knowledge Base discusses how to create and use defined names to automatically update a chart range in Excel.
This Microsoft Knowledge Base article discusses the definitions of basic terms used in charting in Microsoft Excel.
This tip from The Spreadsheet Page shows how to create dynamic ranges that allow a chart to automatically update as new data is added.
The ALT key will snap an embedded Excel chart to the worksheet grid when using a mouse. To move an embedded Excel chart with the arrow keys, first press the CTRL key and the click on the chart. This method selects the chart object, which is the shape that holds the chart.
Peltier Technical Services illustrates how to create waterfall charts that cross the X axis.
