Draw Reference Line

[Anonymous]

Hi guys,

          I have a linear chart, with months on the x-aixs and costs on the y-axis, like this:

Now I would draw a vertical line inside a linear graph, and this line should indicate the current month, like this:

I draw the red line with paint.

I can't use Reference Lines option, because on x-axis I don't have number, but string.

Someone can help me to find a solution?

Thanks

[isorinrusu]

Hi Andrea,

You won't be able to use vertical reference lines unless you use a continuous x-axis (found in axis, between the "axis colours" at the left).

Since you're using months, I think you could convert it to Date and then you'd be able to check the continous axis, thus enabling this option.

Regards,

Sorin.

[avinashelite]

i.sanz11‌ is correct , you need to have continuous x-axis  to get the verticall reference line ...try to have dual format for your Month dim and try that could help

[Anonymous]

I did what you said.

Now the x-axis values looks like this:

How can I show only the first day of the month, like this:

In this second image I disabled the continuous option, but in this case Reference Lines option doesn't work

[stabben23]

Hi,

could you use a combo chart and add Expression like if(Months=vPreviousMonth, 150.00) and use bar?

[woshua5550]

An error bar can almost do it , except a little bit garbages at the end of the line

plz find attachment ,  for your infomation

[woshua5550]

continuous x-axis + reference line + text on axis will make perfect

PFA