AJP Excel Information AJP Excel Information

RE: Dotted line for future data

The line for actual data is solid whilst future data is display with a dashed line.

The line is actually to data series with the 2nd line formatted with the line style dashed.
Select the range A1:C10 and create a normal Line chart.
Format both series lines to give you the solid and dashed line styles.
To make sure the lines appear as one the first Future data point should be the same value as the last Actual data point.


1 Actual Future
2 2002 0.273966
3 2003 0.126777
4 2004 0.584197 0.584197
5 2005 0.898247
6 2006 0.560888
7 2007 0.144713
8 2008 0.632703
9 2009 0.604576
10 2010 0.779904

Created August 2004
Last updated 5th August 2014 

Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page

Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope