how to align two Y-axis

W

wbbane

New Member
Joined
Apr 11, 2006
Messages
9
Excel graph with two y-axis has zeros misaligned; how do you align zeros on two y-axis, desirably placing zeros at the intersection with the x-axis ?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Left click on the 1st y axis to highlight in the chart. Then right click on that axis, click on the Format Axis option, then click on the scale tab, then set you Minimum value to 0. Repeat steps for the second y axis.
 
Upvote 0
Thank you,

however, this way all the negative data disappears, i.e. I can see only the upper part of my graphs!

Is there a way to allign zeros without eliminating negative part?
 
Upvote 0
Just follow the same steps as above and make the minimum point for each of the y axis the same and the x axis will align.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Line on the Y Axis of my chart that I cannot remove
Replies
3
Views
85
awoohaw
awoohaw
S
  • Question
Time on X axis, and Dates on Y axis
Replies
1
Views
59
rlv01
R
M
  • Question
Problem merging two charts (Scatter Bubble + Line)
Replies
2
Views
69
RoryA
RoryA
S
  • Question
Neep help setting up table for plot graph
Replies
0
Views
95
supermom28115
S
O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
337
OrangeJuice
O

Forum statistics

Threads
1,215,043
Messages
6,122,816
Members
449,095
Latest member
m_smith_solihull

Share this page

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
Back
Top