Sometimes, you need to use the normal distribution chart to analyze data, but in Excel, to create a standard bell curve is complex. In Excel 2010 or 2007, specify the option in Vertical axis crosses section.Ĭreate a normal distribution chart (bell curve) with two steps！ If you want to move the Y axis to the middle, you can type the number into At category number text box. If you want to move the Y axis to the right, check At maximum category in Vertical axis crosses section.

Then if you want to move the Y axis to the left, check Automatic in the Vertical axis crosses section. If you are in Excel 2010 or 2007, it will open the Format Axis dialog. Here is a section called Vertical axis crosses can help you to move Y axis to anywhere as you need.ĭouble click at the X axis (horizontal axis) to display the Format Axis pane. In this article, I tell you how to move the Y axis in Excel chart. If you have received a chart sheet and you want to move the Y axis to a new location, how can you solve it? Actually, the Y axis can be moved to left, right or middle as you need. How to move Y axis to left/right/middle in Excel chart?

Kutools excel logarythmic scale boxplot