# How to Show Coordinates in Excel Graph (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate the steps to show coordinates in an excel graph. Undoubtedly, graphs are very useful for easily representing any collected data. But, without perfect labeling of the coordinates, graphs wonâ€™t be that effective. Moreover, without coordinates graphs can create confusion. So, so it is essential to show coordinates in an excel graph accordingly.

## Why Is Showing Coordinates in Excel Graph Necessary?

Basically, coordinates are the numbers or data corresponding to X-axis and Y-axis to show a particular point. A point having X-values and Y-values can be shown in a graph declaring their coordinates. Mainly, the coordinates are important because it helps you to understand the position of a particular point in your graph. Letâ€™s say, you have an air density vs temperature graph of a territory. Now, you want to display coordinates for better visualization. In this case, showing coordinates would be helpful undoubtedly.

## 2 Easy Methods to Show Coordinates in Excel Graph

Weâ€™ll use a sample dataset overview as an example in Excel to understand easily. For instance, we have a dataset of people with their Work Hours in Column C and Daily Pay in Column D. At this point, you want to show x-axis and y-axis coordinates in an excel graph. Follow the steps below to do so:

### 1. Showing Coordinates by Chart Design Tab

This first method will show X and Y axis coordinates in an Excel graph by Chart Design Tab. In this case, we will label the horizontal axis first and then the vertical axis. The steps of this method are

Steps:

• At first, our target is to create a graph. For that, select Column B, Column C, and Column D.
• Then, click on the Insert tab and choose the proper line according to your wish from the Recommended Charts.

• After that, select the graph and click the Chart Design option.
• Then go to Add Chart Element and press on the Axis TitlesÂ option.
• Moreover, select Primary Horizontal to label the horizontal axis.
• In short: Select graph > Chart Design > Add Chart Element > Axis Titles > Primary Horizontal).

• Afterward, if you have followed all steps properly, then the Axis Title option will come under the horizontal line.
• But to reflect the table data and set the label properly, we have to link the graph with the table.
• For doing that, select the Axis Title, go to the Formula Bar, and choose the column you want to link.
• In short: Select Axis Title > Formula Bar > Select Column.

• Lastly, you will get the following result.

• Again, to label the vertical axis, we will go through the same steps as described before but only with a slight change.
• Here, we will select the Primary Vertical option as we are labeling the vertical axis.
• In short: Select graph > Chart Design > Add Chart Element > Axis Titles > Primary Vertical.

• Next to that, we can connect the graph and table in a similar way as described before for the vertical axis((Select Axis Title > Formula Bar > Select Column) to get the below result.

• Afterward, the following result will come onto the screen:

• Next, go to select the graph > Chart Design > Add Chart Element > Data Labels > AboveÂ options.

• Finally, you will get the desired result if you do the same for all the graphs individually.

### 2. Using Chart Element Button to Show Coordinates

This second method will show the X and Y axis coordinates in an Excel graph with Chart Element Button. In this case, we will show coordinates in both the horizontal and vertical axis at the same time. The steps of this method are

Steps:

• Firstly, select the graph.
• Secondly, click on the Chart Elements option and press Axis Titles.
• Thirdly, select both Primary Horizontal and Primary Vertical Then you will see the Axis Title option under both axes.

• Fourthly, you can link the data with the table using the same steps as the first method (Select Axis Title > Formula Bar > Select Column).
• Fifthly, you will get the following result:

• Sixthly, go to select the graph > Chart Elements > Data LabelsÂ options.

• Lastly, you will get the desired result if you do the same for all the graphs individually.

## How to Find Slope of Trendline in Excel

Trendlines are very useful for traders to give them a good direction for their investments. Often traders draw trendlines on their graphs and try to connect them with a particular series of a price values in the market. The resulting line gives them the proper idea of market value or investment direction for their business purposes. So, it is very important to learn to find the slope of trendlines in excel. We will going to use a dataset described and follow the steps below to learn this process:

Steps:

• Firstly, arrange the dataset and select the whole dataset.
• Secondly, go to the InsertÂ option.
• Thirdly, from Recommended Charts, choose a proper Scatter Chart.

• After that, you will get a graph like the below image.

• Next, select the graph and click on the Chart ElementsÂ option.
• Afterward, click on the Trendline option and select the Linear option to show the linear relation between the graph axes.

• If this directly does not work, then select the Trendline option and go to More Options.
• After that, the Format Trendline tab will open on the right side of the window.
• Then, you can select the Linear option to show the relationship.
• Moreover, you can select the Display Equation on Chart option to show the graph equation on the display screen.

• Finally, you will get the result in the image below.

• It is very important to note that the linear relationship equation is y=mx+c. In this case, we have found the equation like y = x-25. If we compare these two equations, we can see that the slope of the is, m=1.

## Things to Remember

• In the first method (Add Axis Title by Chart Design Tab), you must set both axis labels individually.
• In the case of linking the graph with the table, in the Formula Bar, you have to use â€˜=â€™ and then select the desired column.
• These steps will be only applicable to two axes. If any formula or table needed more than two axes, then these steps wonâ€™t be helpful.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.