Trying to add a Reference line on x-axis

[#1]

Hi,

I have a simple bar chart with an x-axis based on month/year, formatted to YY-MMM.  I'm trying to set defined reference line break-points in the x-axis of the chart such as 14-APR, 14-SEP and so on - but can't get it to work.  I've set the x-axis to be continuous and tried to set the reference line expression to every format I can think of.  But whatever I try the reference line doesn't appear.

I'm guessing this is a formatting issue, can someone point me in the right direction?

Thanks

Nick

[tresesco]

Could you post a sample?

[senpradip007]

Please upload a sample application.

[#4]

Hi,

I've enclosed the example chart.  Reference expression is wrong at the moment, I want my reference line to appear on the x-axis at the point of my choosing such as 31-March-2013 and so on...

Thanks!

[#5]

Hi,

Sample application uploaded for you.  Appreciate any ideas.  Thanks.

[Anonymous · Accepted solution]

Nick

For your reference line use an expression like :

          date(date#('14-Mar','YY-MMM') )

Making sure the reference line Location is set to Continuous X.

Best Regards,     Bill

[#7]

you want vertical reference lines?

[#8]

That's worked perfectly - thank you!