Which column is the x and y on excel

Figure 1 — How to plot data points in excel. We will set up a data table in Column A and B and then using the Scatter chart; we will display, modify, and format our X and Y plots.

Figure 2 — Plotting in excel. Figure 3 — X vs. Y graph in Excel. Figure 4 — How to plot points in excel. Figure 5 — How to plot x and y in Excel. Figure 6 — Plot chart in Excel. Figure 7 — Plotting in Excel. We can also add Data Labels to our plot. These data labels can give us a clear idea of each data point without having to reference our data table. Figure 8 — How to plot points in excel. Figure 9 — How to plot x vs.

Figure 10 — Plot x vs. Figure 11 — Format Axis in excel x vs. Figure 12 — How to plot x vs. Click Edit and select the x Axis values. On the left, there will be the different columns of y values. For each line on a graph. Delete the data that belongs to the column with the x axis values. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Learn more. Map one column to x axis second to y axis in excel chart Ask Question. Asked 11 years, 11 months ago. Active 2 years, 4 months ago. Viewed k times. I'm struggling while trying to plot simple data into a simple chart in Excel beta. My data is a very simple one: Value Year 1 5 3 etc. How the heck do you do this?

Improve this question. Add a comment. Active Oldest Votes. I don't understand quite. What kind of graph do you want? Improve this answer. Gaff Rook Rook That looks like an inverted hockey stick graph ; Hooray for the end of global warming!

Please help! This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question 7. Report abuse. Details required :. Cancel Submit. Hi Keetiebug, Based on your description, you want to turn all the data in column A into the x-axis data and all column B into Y-axis data.

Please try the following steps: 1. On the line chart, select the x-axis, then right click and choose Select Data.