Formatting of dual axis

tluber

New Member
Joined
Jan 31, 2011
Messages
1
Hey,

I got the problem that I am plotting a climate chart in excel (precipitation left y axis and temperature right y axis). Since the temperature has negative values but both y axis have to start with the value 0 at the horizontal axis, excel produces negative values for the precipitation, this is not correct. Is there a way to hide the negative values of the left y axis ?
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,250
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top