We will go to Chart Elements and select Data Labels from the drop-down lists, which leads to yet another drop-down menu where we will choose More Data Table options We can click on the Plot to activate the Chart Tools Tab.These data labels can give us a clear idea of each data point without having to reference our data table. If we add Axis titles to the horizontal and vertical axis, we may have thisįigure 7 – Plotting in Excel Add Data Labels to X and Y Plot.Here, we will go to Chart Elements and select Axis Title from the drop-down lists, which leads to yet another drop-down menu, where we can select the axis we want. If we wish to add other details to our graph such as titles to the horizontal axis, we can click on the Plot to activate the Chart Tools Tab.In the drop-down menu, we will choose the second option.įigure 5 – How to plot x and y in Excel Add Axis Titles to X vs Y graph in Excel In Excel 2013 and later, we will go to the Insert Tab we will go to the Charts group and select the X and Y Scatter chart.If we are using Excel 2010 or earlier, we may look for the Scatter group under the Insert Tab.Next, we will highlight our data and go to the Insert Tab.We will set up our data table as displayed below.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. Y plots, add axis labels, data labels, and many other useful tips.įigure 1 – How to plot data points in excel Excel Plot X vs Y In this tutorial, we will learn how to plot the X vs. With such charts, we can directly view trends and correlations between the two variables in our diagram. But I could not find how can I send that data to project as in the first image.We can use Excel to plot XY graph, also known as scatter chart or XY chart. Of course, unlike in the case of report generator, I am not providing the first colmn data, so obviously it's not going to project it. I am talking about projecting my data on X axis (as in the first image above). I am not talking about the range of X axis. I cannot find a property value to assign the explicit values to X-axis. So it generates the graph, but not quite as I would like it to be. In the Waveform Graph, I have to use only the two columns (the gray and blue data) and cannot use the data that has those values of X axis. The second issue is with the Graph control/indicator.Īs you can see in the above image, the X axis has data points which are not like index (0-n) but some specific points. There is an option for Graph Title, but not for the Axis title. In the report generation in Excel, it's actually making nice graphics, but somehow I don't see the option to add a title for "X axis" or "Y axis". While working with graphs and report generator toolkit, I am facing two issues.
0 kommentar(er)
