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.

 

img1

 

To create the line chart in excel follow the below mentioned steps:-

    • Select the data A1:B8.
    • Go to the “Insert” tab, and select the Line with Marker chart from the “Charts” group.

 

img2

 

    • Right clickonthe mouse and select Chart>Select Data.

 

img3

 

  • 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.

 

img4

 

img5

 

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”.

 

img6

 

This is how you can change the value of the X Axis depending on how you want to portray the data.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube