How To Change Horizontal Axis Labels In Excel 2010

Microsoft Excel is undoubtedly the most powerful spreadsheet program bachelor for the Windows Operating System. Being as powerful a spreadsheet programme as it is, Excel is extremely feature-rich. One of the many, many features Excel has to offer to its users is the ability to create charts and graphs. Charts and graphs tin can exist used to represent data in the grade of graphics. Excel is capable of taking text and data and turning information technology into a chart or a graph, plotting each private data point on the graph. In improver, Excel users have a wide range of different options to cull from when it comes to the kind of chart or graph they want to create.

Well-nigh all of the different kinds of graphs and charts Excel has to offering to users accept one thing in common – they accept both an X axis and a Y centrality. The two axes of a graph or nautical chart are used to plot two unlike categories of data points. When you create a graph on Excel, you tin specify the set of values you want to see on the Y axis and the set of values you want to see on the 10 centrality. In some cases, however, the user ends up creating the graph and then wanting to modify the values of, say, the X axis after. Thankfully, that is completely within the realm of possibility.

It is entirely possible for a user to change the values of the Ten axis on a graph in an Excel spreadsheet to a different ready of values in a different prepare of cells on the spreadsheet. In addition, the process you need to go through to change the values of the X axis in a graph in Excel are quite like on all versions of Microsoft Excel. If y'all would like to change the set of values the Ten axis of a graph in Excel has been plotted using, y'all need to:

LaunchMicrosoft Exceland open the spreadsheet that contains the graph the values of whose X axis you want to change.
Right-click on the Ten axis of the graph you want to change the values of.
Click onSelect Data… in the resulting context menu.
Under theHorizontal (Category) Axis Labels section, click onEdit.
Click on theSelect Range push located right next to theAxis characterization range: field.
Select the cells that contain the range of values you want the current values of the Ten axis of the respective graph to be replaced with.
One time you take selected all of the cells that contain the complete range of values, click on theSelect Rangebutton one time again to confirm the choice you lot have made.
Click onOK. Every bit soon as you lot do then, the current values of the 10 centrality of the corresponding graph will be replaced with the new values y'all have selected.
Click onOK in theSelect Data Sourcedialog to dismiss information technology.

While the steps listed and described higher up are intended to be used to modify the values of the 10 axis of a graph in Excel, pretty much the same steps can exist used to change the values of the Y axis of a graph in Excel – all you'll accept to do is right-click on the Y centrality of the graph instep iiinstead of the graph'south X axis.