Excel Graph and Error Bar overlapping on top of columns

[amieon]

Good afternoon

I have a bar chart with YoY performance. I wanted to highlight certain area's by using a vertical line that works with the data.

When using an Error Bar it places the line in between the 2016 and 2017 clustered columns when I want it to appear before or after the clustered columns.


[TABLE="width: 204"]
<tbody>[TR]
[TD="class: xl65, width: 51"]Week[/TD]
[TD="class: xl65, width: 51"]FF 2016[/TD]
[TD="class: xl65, width: 51"]FF 2017[/TD]
[TD="class: xl65, width: 51"]Event[/TD]
[/TR]
[TR]
[TD="class: xl66"]1[/TD]
[TD="class: xl67"]4,976[/TD]
[TD="class: xl67"]4,745[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]2[/TD]
[TD="class: xl67"]5,011[/TD]
[TD="class: xl67"]4,729[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]3[/TD]
[TD="class: xl67"]4,780[/TD]
[TD="class: xl67"]4,589[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]4[/TD]
[TD="class: xl67"]5,039[/TD]
[TD="class: xl67"]5,108[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]5[/TD]
[TD="class: xl67"]5,088[/TD]
[TD="class: xl67"]4,711[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]6[/TD]
[TD="class: xl67"]4,999[/TD]
[TD="class: xl67"]4,535[/TD]
[TD="class: xl68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]7[/TD]
[TD="class: xl67"]4,770[/TD]
[TD="class: xl67"]4,987[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]8[/TD]
[TD="class: xl67"]4,911[/TD]
[TD="class: xl67"]4,894[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]9[/TD]
[TD="class: xl67"]4,833[/TD]
[TD="class: xl67"]4,727[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]10[/TD]
[TD="class: xl67"]4,815[/TD]
[TD="class: xl67"]4,846[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]11[/TD]
[TD="class: xl67"]4,814[/TD]
[TD="class: xl67"]4,634[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]12[/TD]
[TD="class: xl67"]5,167[/TD]
[TD="class: xl67"]4,755[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]13[/TD]
[TD="class: xl67"]4,851[/TD]
[TD="class: xl67"]4,674[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]14[/TD]
[TD="class: xl67"]4,824[/TD]
[TD="class: xl67"]4,610[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]15[/TD]
[TD="class: xl67"]4,785[/TD]
[TD="class: xl67"]4,662[/TD]
[TD="class: xl68, align: right"]7000[/TD]
[/TR]
[TR]
[TD="class: xl66"]16[/TD]
[TD="class: xl67"]4,885[/TD]
[TD="class: xl67"]4,605[/TD]
[TD="class: xl68"][/TD]
[/TR]
</tbody>[/TABLE]

 

[thisoldman]

I'm uncertain about your exact requirements. Do either of these work for you?

Alternative view at Dropbox: https://www.dropbox.com/s/wlalt3a0jiqhhzq/2017-09-28_two_bar_charts_excel.png?dl=0