Add vertical line to 2 graphs with different scale x-axis at the same time

[DavidRoger]

Two graphs with different scale x-axis.
Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.

Trouble is both graph already utilise the secondary axis.
VBA is allowed.

 

[p45cal]

Can you post a simple workbook on the interweb somewhere and link to it here?

 

[DavidRoger]

Can you post a simple workbook on the interweb somewhere and link to it here?

Reply you in a day.

 

[p45cal]

OK

 

[tusharm]

There are probably multiple ways of doing this but they will depend on the kind of chart you have -- XY Scatter / Line / something else.

Two graphs with different scale x-axis.
Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.

Trouble is both graph already utilise the secondary axis.
VBA is allowed.

 

[DavidRoger]

https://docs.google.com/open?id=0BwNWNT_ZZpAFVV9aS2JfS1RGeXc

 

[p45cal]

I was struggling with this - I was hoping to add a second High-Low Series to the same axis but it doesn't want to play (if you know how to add a second OHLC to the same axis then I think I could tweak it down to a HL series, then I'd only have one bar in that series (all the others being blank); this looked promising as I could get a single vertical line placed at the right place when it was the only stock chart on that axis.
Next I wanted to add a column chart - single bar as before, but it didn't want to combine stock and bar charts.
Next I explored vertical error bars on a stock chart with one point and this looks the most promising, I just need to calculate the y-value for that point and the length of the error bars (or have just the minus error bar going down to 0 and set the y-axis minimum according to the other series).
But I find the link you provided fails - have you withdrawn the file?