How To Format X Axis In Excel

Microsoft Excel is undoubtedly the about powerful spreadsheet program available for the Windows Operating Arrangement. Being as powerful a spreadsheet plan equally it is, Excel is extremely feature-rich. I of the many, many features Excel has to offer to its users is the power to create charts and graphs. Charts and graphs tin can be used to represent data in the form of graphics. Excel is capable of taking text and information and turning it into a chart or a graph, plotting each individual data signal on the graph. In add-on, Excel users have a broad range of different options to choose from when information technology comes to the kind of chart or graph they want to create.

Almost all of the dissimilar kinds of graphs and charts Excel has to offer to users have one affair in common – they have both an Ten axis and a Y axis. The two axes of a graph or chart are used to plot two different categories of data points. When y'all create a graph on Excel, you can specify the set of values you want to meet on the Y axis and the set of values you want to see on the X axis. In some cases, however, the user ends upward creating the graph and then wanting to change the values of, say, the X axis subsequently. 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 set of cells on the spreadsheet. In addition, the procedure you need to get through to change the values of the Ten centrality in a graph in Excel are quite similar on all versions of Microsoft Excel. If you lot would similar to change the set of values the X axis of a graph in Excel has been plotted using, y'all need to:

1. LaunchMicrosoft Exceland open the spreadsheet that contains the graph the values of whose Ten axis you desire to alter.
2. Right-click on the Ten axis of the graph you lot want to change the values of.
3. Click onSelect Data… in the resulting context bill of fare.
4. Nether theHorizontal (Category) Centrality Labels section, click onEdit.
5. Click on theSelect Range button located right next to theAxis label range: field.
6. Select the cells that contain the range of values you desire the electric current values of the X axis of the corresponding graph to be replaced with.
7. Once you have selected all of the cells that contain the complete range of values, click on theSelect Rangebutton over again to confirm the choice you lot take made.
8. Click onOK. Equally soon every bit you do and so, the current values of the X axis of the respective graph will exist replaced with the new values you have selected.
9. Click onOK in theSelect Information Sourcedialog to dismiss information technology.

While the steps listed and described above are intended to exist used to modify the values of the 10 axis of a graph in Excel, pretty much the same steps can be used to modify the values of the Y centrality of a graph in Excel – all yous'll have to do is right-click on the Y centrality of the graph infootstep 2instead of the graph's X centrality.

Kevin is a dynamic and self-motivated information engineering professional, with a Thorough knowledge of all facets pertaining to network infrastructure design, implementation and administration. Superior record of delivering simultaneous large-scale mission disquisitional projects on fourth dimension and under budget.

Source: https://appuals.com/change-x-axis-values-excel/

Posted by: clarkcasits.blogspot.com

Share this post