Select the cells that contain the range of values you want the current values of the X axis of the respective graph to be replaced with.Click on the Select Range button located right next to the Axis label range: field.Under the Horizontal (Category) Axis Labels section, click on Edit.Click on Select Data… in the resulting context menu.Right-click on the X axis of the graph you want to change the values of.Launch Microsoft Excel and open the spreadsheet that contains the graph the values of whose X axis you want to change.If you would like to change the set of values the X axis of a graph in Excel has been plotted using, you need to: In addition, the process you need to go through to change the values of the X axis in a graph in Excel are quite similar on all versions of Microsoft Excel. It is entirely possible for a user to change the values of the X axis on a graph in an Excel spreadsheet to a different set of values in a different set of cells on the spreadsheet. Thankfully, that is completely within the realm of possibility. In some cases, however, the user ends up creating the graph and then wanting to change the values of, say, the X axis afterwards.
When you create a graph on Excel, you can specify the set of values you want to see on the Y axis and the set of values you want to see on the X axis. The two axes of a graph or chart are used to plot two different categories of data points. In addition, Excel users have a wide range of different options to choose from when it comes to the kind of chart or graph they want to create.Īlmost all of the different kinds of graphs and charts Excel has to offer to users have one thing in common – they have both an X axis and a Y axis. Excel is capable of taking text and data and turning it into a chart or a graph, plotting each individual data point on the graph. Charts and graphs can be used to represent data in the form of graphics. One of the many, many features Excel has to offer to its users is the ability to create charts and graphs. Being as powerful a spreadsheet program as it is, Excel is extremely feature-rich. Microsoft Excel is undoubtedly the most powerful spreadsheet program available for the Windows Operating System.
0 kommentar(er)
