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.

 

A B C
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-2014 Andy Pope