#How to change excel x axis data how to#

You can also use the angle axis buttons on the chart toolbar to change the angle of the value and category axis. Click the OK button to accept the axis format changes.The Alignment tabs let you define text orientation (see lesson 11).The Number tab lets you define the format of numbers displayed in the axis (see lesson 12).The Scale tab lets you define numeric intervals on the value (Y) axis scale.The Patterns tab lets you define borders and tick marks.The Format Axis dialog box contains five different tabs-Patterns, Scale, Font, Number, and Alignment-that can be used to format the axis.Click the Format button on the Chart toolbar (or double-click the chart axis).

Click anywhere in the axis label you want to edit:.When formatting the axis labels in your chart, you can adjust the numbers on the scale of the chart, as well as change font, color, and style. The Y axis runs up and down on the graph, while the X axis runs left to right. The number of items might be plotted on the Y axis, while the month may be plotted on the X axis. The number of items sold in January is data on two dimensions: number of items and month. In Excel, a graph represents a data in two dimensions. We've previously made reference to a Y axis and an X axis in Excel. The only way to change the actual text that appears in the chart legend is to change the source data in the worksheet. Click the OK button to accept the chart legend format changes.

The Placement tab lets you define the location where the legend will appear on the chart.

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 axis you want to change, select Format Axis from context menu.

The Font tab lets you define font, font style, size, and color. In Excel 2013, you can change the scale of axis in a chart with following steps: 1.

The Patterns tab lets you define borders and fill colors.

The Format Legend dialog box contains three different tabs-Patterns, Font, and Alignment-that can be used to format the chart title.

Click the Format button on the Chart toolbar (or double-click the chart legend).

(This button acts like a toggle by turning the display on or off.)

Press the show/hide legend button on the Chart toolbar to turn on the legend display.

The chart legend, like the chart title and category axis labels, can be formatted to your liking. Like a roadmap, the legend identifies what different colors or objects represent in the chart. Is this your first time on Eas圜lick? We’ll be more than happy to welcome you in our online community.The chart legend displays useful information about the chart.

#How to change excel x axis data how to#

If you found this tutorial helpful, give us a like and watch other video tutorials by Eas圜lick Academy. Learn how to use Excel in a quick and easy way! How to Add an Average Line in an Excel Graph.The links are included in the list below.ĭon’t miss out a great opportunity to learn: If you’re interested in learning more, for example how to add or adjust other elements in a graph, have a look through more tutorials by Eas圜lick Academy. This is a handy way to change scaling in a graph according to your needs. If we change the ‘Major’ units value from 20 to 40 and press Enter, the units on the vertical axis will change based on the adjusted settings. Now, the unit value is 20, which means that the difference between the numbers on this axis is 20. When we press Enter, Excel displays the changes in the graph, which makes the data clearer and easy on the eye.Īt the same time, we can adjust the units displayed on the vertical axis. To improve the readability of the graph, let’s change the upper bound to 160. For example, to get the same result with a bar chart I could simply sort the source data. Keep in mind that that you dont have reverse the axis in a case like this. How to Change the Scale of Vertical Axis in ExcelĬurrently, the bottom bound value is 0 and the upper bound value is 400. To reset the axis to its default, visit axis options again and set the axis crossing to automatic, and untick the reverse order checkbox. In ‘Axis Options’, we can set the graph bounds and units as needed.īut let’s go through it step by step.

Select ‘Format Axis’, after which you’ll see a pane with additional options appear on the right. To adjust the scale of a graph, right-click on the vertical axis of the graph, just where you see the values. 2 How to Change the Scale of Vertical Axis in Excel How to Adjust the Scale of a Graph