Time dependent chart area visualization
When creating graphs related to spans of time periods (e.g. data on weekly or monthly basis), it would be useful to instruct Excel not to show data if are in the future for specified data series.
For example, if you want to show budget/target vs actual, a chart is much better to view if represents just the budget and dynamically shows the actual, rather than filling the chart areas of a set of zero points. Another scenario is when you want to show some time dependent data, like actual per week. If I want to show the data up to current week, at the moment the only choice that I have is to manually modify the chart area weekly in order to include the current week. In other words, I manually expand the X-axis. An alternative, that makes a poor view though, is to have a chart that includes all the weeks of the year, accepting the fact that values from current week+1 are shown as zero. However, just looking at such representation how can you know if a point is a real zero or not?