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. Click the Add Chart Data button near the selected. On the next screen that appears, click Add. Create a column, bar, line, area, pie, doughnut or radar chart Click Click a chart or drag it to the sheet. 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):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |