In Excel 20’s Format Axis dialog, go to Axis Options section, then type 1 into the text box beside Interval between tick marks, then check Specify interval unit option and type 1 into the text box beside it. Right click at the depth axis, and select Format Axis option in the context menu. ![]() To change the scale of 3d chart depth axis, you just need to adjust Interval between tick marks and Specify interval unit options. ![]() Now I am talking about changing the scale of the 3d chart depth axis to solve this problem in Excel. ![]() When you insert a 3d chart, you may be confused that why the z axis doesn’t show all the labels on the chart as below screenshot show. How to change 3d chart depth axis in Excel?
0 Comments
Leave a Reply. |