Hi,

There are various ways of addressing this problem.
See the following for examples of adding lines to charts.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Wilkesy50 wrote:
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!



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info