You have to adjust these values in your case.
In Series X values, put =Sheet1!$C$2:$C$11 where $C$2 is the first numeric cell of the data column B (which you want as X axis) and $C$11 last in my case. On the "Edit Series" menu that pops up, enter a series name. On the next screen that appears, click Add. Right click on the blank canvas and choose Select Data: This will bring a blank graph canvas on your screen. Without selecting any data, go to insert>scatter and choose a graph type.
See this:įor your second problem (to plot 'B' as X and 'A' as Y): You will have the result on your screen.After that, go to Insert>Scatter and choose a graph type:.Select all the data that you've arranged like this:.For your first problem (to plot multiple 'y' values), do the following:
0 kommentar(er)
