Brilliant Change Axis Excel
Change the way that data is plotted Click anywhere in the chart that contains the data series that you want to plot on different axes.
Change axis excel. Change the axis scale in the chart. Right-click the graph to options to format the graph. If you want to move the Y axis to the right check At maximum category in Vertical axis crosses section.
The chart uses text from your source data for axis labels. By default Excel automatically determines the values on the vertical axis. On the Design tab in the Data group click Switch RowColumn.
In addition to changing the text of labels you can also change their appearance by adjusting formats. In the options window navigate to Select Data to change the label axis data. First right-click on either of the axes in the chart and click Select Data from the options.
Select the source data and then create a chart with clicking the Insert Scatter X Y and Bubble Chart or Scatter Scatter with Smooth lines on the Insert tab. Right click at the axis you want to format its labels as thousandsmillions select Format Axis in the context menu. Click the arrow next to.
If you dont want to change the text of the source data you can create label text just for the chart youre working on. Right click the chart whose X axis you will change and click Select Data in the right-clicking menu. Microsoft Excel automatically determines the minimum and maximum scale values as well as the scale interval for the vertical axis based on the data included in the chart.
By the way you can use the same steps to make most of the changes on the Y-axis. Once you choose Select Data an Edit Series window will open with information on the axis. In the new chart right click the axis where you want to show labels as percentages and select Format Axis from the right-clicking menu.