How to move Y axis to left/right/middle 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. In this article, I tell you how to move the Y axis in Excel chart.
Here is a section called Vertical axis crosses can help you to move Y axis to anywhere as you need.
Double click at the X axis (horizontal axis) to display the Format Axis pane. See screenshot:
If you are in Excel 2010 or 2007, it will open the Format Axis dialog.
Then if you want to move the Y axis to the left, check Automatic in the Vertical axis crosses section.
If you want to move the Y axis to the right, check At maximum category in Vertical axis crosses section.
If you want to move the Y axis to the middle, you can type the number into At category number text box.
In Excel 2010 or 2007, specify the option in Vertical axis crosses section.
Create a normal distribution chart (bell curve) with two steps！
|Sometimes, you need to use the normal distribution chart to analyze data, but in Excel, to create a standard bell curve is complex. Here, Kutools for Excel provides a tool - Normal Distrubition/Bell Curve can quickly create the bell curve chart or frequency histogram chart based on data with two steps. Download this tool with free 30}-day trial now.|
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 1 years agoThis doesn't work if the X axis range is all negative. Automatic and max both force it to the right, in that case. They should have included "Left" or "Minimum" as an option for such cases