6 Replies Latest reply on Jan 23, 2018 7:10 PM by Shinichiro Murakami

# Add vertical reference line to where average line intersect with plotted line

Hello community,

I have a question regarding the reference line, I would like to add another reference line to an intersection of an existing reference line and plotted line, please see below

basically I need a vertical line at where horizontal line and orange line meets(at 7.774), and indicate the x axis label

I am using the below formula to find the x label which is Month,

if WINDOW_AVG(sum([Cash management]))=AVG([Cash management]) then MIN([#Th Week]) end

and:

window_max([Month = Average]), and then added to detail, created a reference line as below:

However the vertical line shows wrong month: the max month in the X axis.

Can anyone help?

Thanks!

• ###### 1. Re: Add vertical reference line to where average line intersect with plotted line

HI Tommy,

Could you please attach packaged workbook. (**.twbx)

Thanks,

Shin

• ###### 2. Re: Add vertical reference line to where average line intersect with plotted line

Hello Shinichiro,

I have attached the workbook in my post,

Thanks!

• ###### 3. Re: Add vertical reference line to where average line intersect with plotted line

Hello Shinichiro, I forgot to change the columns into "Continues" in the Dummy work book, I believe you need it to be continues to show a vertical reference line.

• ###### 4. Re: Add vertical reference line to where average line intersect with plotted line

HI Tommy,

Not sure I understand the request correctly, anyways

Assuming "Left End Plot"is always below AVG...

Thanks,

Shin

• ###### 5. Re: Add vertical reference line to where average line intersect with plotted line

Thank you! this seems to work,

however what is that 0.5 offset for? I did find that without -0.5 the vertical reference line was not perfectly aligned at the intersection.I have to adjust between 0.5 and 1 to align it properly based on the view I want.

• ###### 6. Re: Add vertical reference line to where average line intersect with plotted line

HI Tommy,

Simply without 0.5, the line is on the circle plot of Line chart.

With 0.5, the line is in-between plots of line chart.

Thanks,

Shin