How to Change the Value of X Axis in Microsoft Excel 2010 If we need to change the value of the X-Axis or any axis of the chart, we have to first prepare a chart in Microsoft Excel 2010. This will help us understand the steps involved. Let’s take an example and understand: – We have data in range A1: B8, in which column A contains selling price and column B contains quantity. We will create a line chart. To create the line chart in excel follow the below mentioned steps:-. Select the data A1:B8.
![Values Values](/uploads/1/2/5/4/125485119/641613418.png)
Go to the “Insert” tab, and select the Line with Marker chart from the “Charts” group. Right clickonthe mouse and select ChartSelect Data. On the left side in the “Legend Entries (Series)” box uncheck “Quantity” and click on ok. The chart will show the data only for the Selling Price. To change the value of X Axis follow the below mentioned steps:-.
Click on the Chart. Right click on the mouse and select chart Select Data. The “Select Data Source” dialog box will appear. On the left side in the “Legend Entries (Series)” box check on “Quantity” and uncheck on“Selling price”.
This is how you can change the value of the X Axis depending on how you want to portray the data.
Sep 26, 2018 - Learn how to add a secondary axis to your Excel charts on a Mac, PC, or in a Google Doc spreadsheet. All Numbers & Locations. X axis with two different sets of Y-axis data with two different scales. On the far righthand side, select the 'Change Chart Type' icon and hover over the 'Line' graph option.