Impressive Plotting X Vs Y In Excel

I am doing a scatter plot.

Plotting x vs y in excel. Make the selection as below. Click on the chart Chart filters select data Edit in the edit series select the range in the both X and Y series and press ok. After you complete this for the x-axis repeat for the y-axis click on any number on the y-axis and choose a narrow range.

After selecting the one of the above methods the data adds to table successfully. Series Name Point X value Y value position where X value is the number I actually want on the X axis but position is where is actually showing up on the X. The moles of magnesium.

Id like to plot both data sets of absorption Y on one time axis X but I cant find a way to include the two different sets of X. Nothing fancy basic. I have been trying to plot two data sets in excel 2013 on an XY straight line graph.

Both sets are plots of absorption Y against time X but absorption was measured at different times for each data set. I have a multiple columns representing Y values each against a specific x value. And when you edit the data where you created a scatter chart the data is changes automatically in the scatter chart.

Drag it down and choose Chart Options. Go to Select Data for your Excel graph. If I select just 1 set of values 1 column of X values and 1 columns of Y values with a series name on top it will plot the Y values vs the position 1-35 rather than the actual X values and when I hover over them it will say something like.

Another solution is use a J label with the chart. You can even use VBA to create a cool vector plot in Excel. Plotting the graph using a secondary axis and adding axis titlesPresented by Dr Daniel Belton.