Smart Switch Axis In Excel Chart
In this video you will learn how to change horizontal or x-axis Values in Excel charts.
Switch axis in excel chart. Right-click the X-axis in the chart you want to change. Click the Format Selection button to see the Format Axis window. That way you can follow this guide step.
Value axis or vertical axis Y and category axis or horizontal axis X. In charts axis labels are shown below the horizontal also known as category axis next to the vertical also known as value axis and in a 3-D chart next to the depth axis. Change The Scale Of Vertical Value Axis In A Chart.
Select the Pivot Chart that you want to change its axis and legends and then show Filed List pane with clicking the Filed List button on the Analyze tab. Go to Insert Charts Clustered Column this will give you the default chart Click on the chart and choose the Design tab Go to Data Switch Row Column. 1 In Excel 2013s Format Axis pane expand the Number group on the Axis Options tab click the Category box and select Percentage from the drop down list and then in the Decimal Places box type 0.
Open the Excel file with the chart you want to adjust. To change the label you can change the text in the source data. The chart uses text from your source data for axis labels.
Click the axis title box on the chart and type the text. On the Format Axis window tick the Values in reverse order checkbox. Then if you want to move the Y axis to the left check Automatic in the Vertical axis crosses section.
Then click on Select Data. In the chart click the horizontal axis or do the following to select the axis from a list of chart elements. Rotating the Excel chart has these basic 5 steps.