This is my latest favorite way, besides Sparklines, to quickly visually audit the trend of a projected data series:
1. Select the entire series of values (excluding the line item label) (All together: Shift + Ctrl + Right Arrow)
2. Alt + N + C + Enter
Voila, a column graph, in 5 seconds.