Custom format to add letter to specified X-axis dates

[MassMP]

Hi, I have a line chart with dates formatted as YYYY on the X-axis. For some years the data charted represent actual values while some years represent estimates, for which reason I would like to add an "e" following the YYYY format. So problem is: how to do a custom format which will put an "e" at the end of the x-axis label for all years>2012 but not for those <2012. Thanks in advance!

 

[pgc01]

Hi

It's not clear from your post what happens for the year 2012. Since we are still in 2012 I'll assume also the "e" in this case.

Use the format:

[>40908]yyyy"e";yyyy

Remark: 40908 is the number value corresponding to 2011-12-31.

 

[Rick Rothstein]

Since we are still in 2012...

 

[pgc01]

Thank you Rick.

With all the back and forth travelling, I misread my time space continuum coordinates.


So, assuming we are in 2013, use:

[>41274]yyyy"e";yyyy

Remark: 41274 is the number value corresponding to 2012-12-31.

 

[MassMP]

That works. Thanks very much!

 

[pgc01]

You're welcome. Thanks for the feedback.