Excel 2003
I have a very simple Line graph. The series of data displays historic information up to the current month, and budgeted data in the future. I would like to insert a vertical line or some other type of marker to indicated where the actuals end and the projections begin.
My Data looks essentially like this
1 100,000
2 150,000
3 125,000
4 200,000
5 250,000
If the current month is 3, then 4 and 5 are budgeted, not actual. I want the graph viewer to know immediatley what is real, and what is budget by some sort of visual cue.
Any ideas?
I have a very simple Line graph. The series of data displays historic information up to the current month, and budgeted data in the future. I would like to insert a vertical line or some other type of marker to indicated where the actuals end and the projections begin.
My Data looks essentially like this
1 100,000
2 150,000
3 125,000
4 200,000
5 250,000
If the current month is 3, then 4 and 5 are budgeted, not actual. I want the graph viewer to know immediatley what is real, and what is budget by some sort of visual cue.
Any ideas?