How to set X and Y axis in Excel

In this video tutorial we will show you how to set x and y axis in excel.

Open the excel document you want to edit. Select the part of the text you want to edit. Go to “Insert” tab. Click on “Scatter” and select the preferred scatter.

Add diagram

After the diagram appears, right-click to it and choose “Select data”.

Choose Select Data

Select the column you want to change and click “Edit”. In next window you can set x and y values. After the changes have been done, press “ok” and see how the diagram changes.