Excel Chart

Are you thwarted by an Excel chart that drops to zero — and off the charts — when data is not available for the current period? Here's a quick fix.