Eloise T Active Member Mar 4, 2016 #1 Please see the chart below. How do you "adjust" the amounts/increments on the y-axis of the chart? i.e how to set the range ...from 10,000 per segment to 5,000 per segment, or even 1,000 per segment) or any other increment I choose?
Please see the chart below. How do you "adjust" the amounts/increments on the y-axis of the chart? i.e how to set the range ...from 10,000 per segment to 5,000 per segment, or even 1,000 per segment) or any other increment I choose?
Chihiro Excel Ninja Mar 4, 2016 #2 If 2013 or later. Right click on vertical axis. Choose, format axis. Then go to axis option (the icon to the right), set maximum for Bounds and adjust Major Units to whatever you like.
If 2013 or later. Right click on vertical axis. Choose, format axis. Then go to axis option (the icon to the right), set maximum for Bounds and adjust Major Units to whatever you like.
Hui Excel Ninja Staff member Mar 4, 2016 #4 No Right click on the axis and select Format Axis Set The Maximum and Minimum Values and the Major Units as necessary
No Right click on the axis and select Format Axis Set The Maximum and Minimum Values and the Major Units as necessary
