[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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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,136,926
Messages
5,678,614
Members
419,776
Latest member
mikelowski

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