Stunning Excel Chart Switch X And Y Axis

In this video tutorial we will show you how to set x and y axis in excelIn this video tutorial we will show you how to set x and y axis in excelOpen the ex.

Excel chart switch x and y axis. Be sure to select the axis values not the axis title. Click OK to accept changes in Edit Series and then click OK one more time. For most chart types the vertical axis aka value or Y axis and horizontal axis aka category or X axis are added automatically when you make a chart in Excel.

A horizontal axis or x-axis and a vertical axis or y-axis. Click the chart and then Chart Filters. Here we will go to Chart Elements and select Axis Title from the drop-down lists which leads to yet another drop-down menu where we can select the axis we want.

Right click the axis you want to change select Format Axis from context menu. See screen shot below. Click somewhere on the chart to select it.

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. Right-click the scatter chart and click Select Data in the context menu. Now the scatter chart looks like a line chart with years on the X-axis.

By definition these axes plural of axis are the two perpendicular lines on a graph where the labels are put. This step by step tutorial will assist all levels of Excel users in learning how to change axis values. Click the x-axis or y-axis directly in the chart or click the Chart Elements button in the Current Selection group of the Format tab and then click Horizontal Category Axis for the x-axis or Vertical Value Axis for the y-axis on its drop-down list.

You data set is not a good data set for 3D chart. You should now see 3 new tabs appear at the top of the screen called Design Layout and Format. You can switch the data for all series as we did in this tutorial or for just one series or you can switch the axis titles or the axis scales and titles or you can just switch.