Microsoft Excel is without a doubt the most powerful spreadsheet program available for the Windows operating system.. As powerful as a spreadsheet program is, Excel is extremely feature rich. One of many, many features that Excel has to offer its users is the ability to create tables and graphs. Tables and graphs can be used to represent data in the form of graphs. Excel is capable of taking text and data and converting it into a table or graph, plotting each individual data point on the graph. What's more, Excel users have a wide range of different options to choose from when it comes to the type of chart or table they want to create.
Almost all of the different types of charts and tables that Excel has to offer users have one thing in common: have an X axis and a Y axis. The two axes of a graph or table are used to plot two different categories of points. data. When creating a chart in 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. However, in some cases, the user ends up creating the chart and then wants to change the values of, for example, the X axis after. Fortunately, that's completely within the realm of possibility.
It is entirely possible for a user to change the X-axis values in a chart in an Excel worksheet to a different set of values in a different set of cells in the worksheet.. What's more, the process to follow to change the X-axis values in an Excel chart is quite similar in all versions of Microsoft Excel. If you want to change the set of values with which the X axis of a graph has been graphed in Excel, you have to do it:
PROFESSIONAL SUGGESTION: If the problem is with your computer or laptop, you should try using Reimage Plus, which can scan repositories and replace damaged and lost files. This works in most cases, when the problem originates due to system corruption. You can download Reimage for By clicking here
-
Start Microsoft Excel and open the worksheet that contains the chart whose X-axis values you want to change.
-
Right-click on the X axis of the chart whose values you want to change.
-
Click Select data … in the resulting context menu.
-
In the Horizontal Axis Labels section (category), click edit.
-
Click the Select Range button right next to the Axis Label Range field:
-
Select the cells that contain the range of values with which you want the current values of the X-axis of the respective chart to be substituted.
-
Once you have selected all the cells that contain the full range of values, click the Select Range button one more time to confirm the selection you have made.
-
Click ok. As soon as i do, the current values of the X axis of the respective chart will be replaced by the new values you have selected.
-
Click OK in the Select Data Source dialog to dismiss it.
Although the steps listed and described above are intended to be used to change the X-axis values of a chart in Excel, Virtually the same steps can be used to change the Y-axis values of a chart in Excel – all you will have to do is right click on the Y axis of the graph in step 2 instead of the X axis of the graph.
SUGGESTION: If none of the methods have solved your problem, we recommend that you use the Reimage repair tool, which can scan repositories to replace damaged and lost files. This works in most cases, when the problem originates due to a system corruption. Reimage will also optimize your system for maximum performance. You can download Reimage for By clicking here
