Impressive Excel Chart Move Axis To Bottom

Excel tutorial how to reverse a chart axis how to move chart x axis below negative values zero bottom in excel how to sort your bar charts depict studio moving the axis labels when a powerpoint chart graph has both positive and negative values gantt chart.

Excel chart move axis to bottom. To change the label you can change the text in the source data. Heres the resulting slide after increasing the font size of both axes and removing some irrelevant junk. Then in Labels section change Label Position to Low.

In the Horizontal axis crosses section of the Format Axis dialog select either Maximum axis value or Axis value and specify a negative number. Select the cluster column chart whose horizontal axis you will move and click Kutools Chart Tools Move X-axis to NegativeZeroBottom. These instructions are for Excel 2003 which is the version you indicate in you profile as the one you are using.

However Ive noticed that if the chart includes a y axis and you choose this option Excel moves the axis from the bottom of the plot area to the top. Right-click one of the labels of the axis and choose Font. If you are in Excel 2010 or 2007 it will open the Format Axis dialog.

The X-Axis labes on the zero line in the middle of the chart. If you are using a different Excel version please update your profile and call back. Under Units next to Base select Days Months or Years.

3 on Format Axis pane expand the Labels section select Low option from the Label Position drop-down list box. If you want to move the Y axis to the right check At maximum category in Vertical axis crosses section. The X axis are the periods and the Y axis is the percentage for each period.

Then the horizontal X axis is moved to the bottom of the cluster column chart immediately. Select the X axis Category axis open the Format Axis dialog and set Tick mark labels to Low. After the change of label position the chart should look like.