Changing Y-axis

JRCBoston

Board Regular
Joined
Sep 19, 2003
Messages
127
Hi,

How can I change the way that the labels and data show on the Y axis? I want negative numbers to be plotted above the x axis rather than below and positive below the x axis. Is this possible?

Thank you.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,040
Office Version
  1. 365
Platform
  1. Windows
You can right click on the Y-axis and select Format Axis, under Axis options, tick "Values in reverse order"
 

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,334
Members
409,863
Latest member
stacy09
Top