You'll have your desired graph right there. Press 'OK' and then again 'OK' on the menu that appear.Similarly, put in the values of Series Y, as shown below: For example, if C20 is your last numeric cell in data column B and C2 first, change the given formula to: =Sheet1!$C$2:$C$20 where Sheet1 refers to the sheet name. 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. Share the x-axis for multiple values along the y-axis for scatter and bubble charts Click the chart to select it, then click the Edit Chart Data button. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |