Fine Beautiful Excel Change X And Y Axis

Click somewhere on the chart to select it.

Excel change x and y axis. To create a column chart execute the following steps. On the Character Spacing tab choose the spacing options you want. Click on the Design tab.

However you can customize the scale to better meet your needs. X-axis is the passage of time in years and y-axis is the net costbenefit occuring through time. Choose Scatter with Straight Lines.

A new window will open. Set X and Y axes Click inside the table. Right-click the scatter chart and click Select Data in the context menu.

Axis Type Axis Titles Axis Scale. By default Microsoft Office Excel determines the minimum and maximum scale values of the vertical value axis also known as the y axis when you create a chart. Select the range A1B7.

In the Format Axis pane in the right click the Axis Options button and change the number in the Major box in the Units section. When you open the Format tab click on the Format Selection and click on the. How to Change X and Y axis in Excel graph or chart.

When the values that are plotted in the chart cover a very large range you can also change the value axis to a logarithmic scale also known as log scale. To switch between the X and Y axis in a scatter chart in Excel please do as follows. After selecting the one of the above methods the data adds to table successfully.