Exemplary Switch Axis Excel Chart
Or it makes my x axis disappear in my chart.
Switch axis excel chart. Right click the axis you want to change select Format Axis from context menu. Click anywhere in the chart. When I check the box Excel reverses the plot order.
In our example we will change the minimum scale to 15000 and maximum scale to 55000 on the vertical axis. Select the axis that we want to edit by left-clicking on the axis. This is usually in the third grouping of the menu that pops out at your cursor.
Right-click on either the X-axis of the scatter chart or its Y axis doesnt really matter which one. See screen shot below. While Ive used a Combo Box any object with a cell link will work.
February 18 2019 at 944 pm. If we want to change the axis scale we should. To sort X Axis alphabetically the quick way is to sort the table.
Select the chart sheet then click Developer Insert Combo Box Form Control. To switch between the X and Y axis in a scatter chart in Excel please do as follows. Right-click the scatter chart and click Select Data in the context menu.
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. On the Design tab in the Data group click Switch RowColumn. The chart uses text from your source data for axis labels.