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

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

Watch MrExcel Video

Forum statistics

Threads
1,095,362
Messages
5,444,022
Members
405,260
Latest member
Khauff

This Week's Hot Topics

Top