For the year label, you have to create a calculated field that will return a string value : only year for past ; current year + 'e' for current ; future year+'f' for future
This will gave you the following result :
For color, there is multiples solutions, one of them is to create a special calculated field the same way as "custom year" field :
And finally, use this field as color in your chart :
Hope it will help.
Great, thanks Fanny - once I got the date format in Excel to stop converting to 1905, it worked fine. Is it possible to keep the same color and make it 90% and 80% density for present & future?
You can modify the color for present & future by double clicking on legend and put similar colors but, if I'm right, the transparency can not be set for only one or two specific legend value(s).
It will be a 90% transparency for all legends colors, not only one or two.