Yearly Gridlines

[bwhite]

We use a mix of Excel 2013 and 2016.

We have a chart displaying 4 years of monthly data.
They would like a vertical black line at each year boundary.

I tried adding a picture but that didn't work.
Here is a link to the picture
https://1drv.ms/f/s!AlPB4hkzs7kXlWqJ_Zl-CZ8em6aN

As you can see, all I can get is vertical lines for every month.

It looks like you should set the major to year, but that doesn't have any effect.

I'm not actually showing any labels on the axis itself. Those are in the cells below the chart.

Any ideas?

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at "Lines - Add Lines to a Chart"
in
Jon's Excel Charts and Tutorials - Index
I have used one of these techniques before to add one or more vertical lines to a line chart using the error bar method.

 

[bwhite]

Hello and welcome to The Board.
Have a look at "Lines - Add Lines to a Chart"
in
Jon's Excel Charts and Tutorials - Index
I have used one of these techniques before to add one or more vertical lines to a line chart using the error bar method.

Thanks, that worked great.
Luckily, I wasn't already using the second axis.