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.
Download Practice Workbook
You can download the practice workbook from here.
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
- 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
- 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:
- 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.
Henceforth, follow the above-described methods. Hopefully, these methods will help you to show coordinates in an excel graph. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.
- What Are Data Labels in Excel (Uses & Modifications)
- How to Edit Data Labels in Excel (6 Easy Ways)
- Data Labels in Excel Pivot Chart (Detailed Analysis)
- How to Move Data Labels In Excel Chart (2 Easy Methods)
- Show Data Labels in Excel 3D Maps (2 Easy Ways)
- Remove Zero Data Labels in Excel Graph (3 Easy Ways)
- How to Add Data Labels in Excel (2 Handy Ways)