Time line in excel graph

W

Wilkesy50

I need a vertical line in my graph to show that the graph information after
the line is the future predicted outcomes. I've tried countless different
options and cant seem to find how to do this!
 
W

Wilkesy50

That's great Andy, Thanks. BUT it's a bit complicated for me to follow! Is
there anywhere where I can find an 'idiots guide'?

Many Thanks,

Nicole
 
A

Andy Pope

Hi,

Ok lets start with what type of chart and data do you currently have?

Cheers
Andy
 
W

Wilkesy50

It is a line chart. Across the bottom are some dates (random months...well I
tried to have random months like in my original chart, but I couldnt get that
so it's periods of three months). Up the side are total point numbers. The
series line charts the total point numbers, and at a certain point i need a
line to signify the present, and then afterwards predicted results.
 
Top