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

Big Monkey

Active Member
Joined
Nov 5, 2005
Messages
255
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?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
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

Active Member
Joined
Nov 5, 2005
Messages
255
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.
 

Forum statistics

Threads
1,171,274
Messages
5,874,783
Members
433,074
Latest member
alexbecker220

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top