Align Zero of Primary Axis & Secondary Axis

**sfzans** · 05-04-2023, 08:09 AM

Hi
I have a set of data linked to a Cost Code and the graphs are shown as per the filtered cost code.
On the primary Axis is the monthly Expense (Clustered Column) on the secondary axis is the Total Forecasted (Line).
Problem is the secondary aixs ZERO is not aligning to Primary axis.
Manually i can allign the axis. But i need help in aligning it automatic as soon as cost code is changed.

Please let me know if the worksheet is need to be uploaded.

**MrShorty** · 05-04-2023, 09:49 AM

I'm not aware of any built in way to do this. I would expect to use something like this strategy: https://peltiertech.com/chart-udf-control-axis-scale/ It would need to be modified to read the primary axis scale properties and use those to calculate the desired values for the secondary axis scale, then write those values into the secondary axis scale properties.

**6StringJazzer** · 05-04-2023, 09:56 AM

I agree with MrShorty on this. There is no Excel feature to do this automatically. A VBA solution would work.

There may be a way to contrive your data to force them to match. That would involve adding a fake data point for the series on the right axis that has a y value calculated to align the 0 value with the 0 value on the left axis. But I can't advise on that without the file. Please see yellow banner at the top of the page.

**sfzans** · 05-04-2023, 10:02 AM

Thanks MrShorty.
some deep searches into this forum gave me an excel sheet with a macro. It serves my purpose through a macro. though need to click the assigned macro button everytime i switch the code.
Also ZERO is not shown on the axis but data are aligned (can live without that).