How do you put a Y-axis on top in Excel?

Display or hide axes (Office 2010) This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Axes group, click Axes. Click the type of axis that you want to display or hide, and then click the options that you want.

How do I change the y-axis in Excel 2007?

Changing the Display of the Axes

1. Click the chart.
2. From the Layout command tab, in the Axes group, click Axes.
3. To change the appearance of the x-axis, select Primary Horizontal Axis. OR. To change the appearance of the y-axis, select Primary Vertical Axis.
4. Select the desired option. The option is applied.

How do I change the order of the y-axis in an Excel chart?

Luckily, Excel includes controls for quickly switching the order of axis values. To make this change, right-click and open up axis options in the Format Task pane. There, near the bottom, you’ll see a checkbox called “values in reverse order”. When I check the box, Excel reverses the plot order.

How do I add axis title to top in Excel?

Click the chart, and then click the Chart Layout tab. Under Labels, click Axis Titles, point to the axis that you want to add titles to, and then click the option that you want. Select the text in the Axis Title box, and then type an axis title.

How do you move the Y axis left to right?

Move Y axis to left/right/middle

1. Double click at the X axis (horizontal axis) to display the Format Axis pane.
2. If you are in Excel 2010 or 2007, it will open the Format Axis dialog.
3. Then if you want to move the Y axis to the left, check Automatic in the Vertical axis crosses section.

How do I move the axis labels from top to bottom in Excel?

Was this reply helpful? Right-click a value axis label and select Format Axis… from the context menu. Under Horizontal axis crosses, select Axis value, and enter a suitable value in the box, e.g. -40% (or -0.4). Click OK.