[Charts] Line chart type on secondary axis...

[Big Monkey]

OK, so I have 4 series set up. 3 Columns on the primary axis, and a line on the secondary axis.

Everything is fine and here is what I would like to change if possible:

The secondary axis has markers and they are charted right in the middle of the 3 columns per value.

My question is...is it possible to move the markers so that they align to the column I pick? Like the 1st column or second column instead of the middle?

 

[Datsmart]

Adjust the scale of the secondary axis so the markers align as you wish. You can even set the scale to start with a minus number to slide the scale higher on the chart.

 

[Big Monkey]

Thanks Datsmart.

If I understood you correctly, that doesn't quite do the trick for me. I've already adjusted the scaling on the secondary axis so that the line shows up above the columns and out of the way.

What I'm wanting is to move the markers horizontally, not vertically.