Do the same with your Y- values (2,4,6,8). You’ll then see command boxes with a little red-blue button on the right -click on that one for “X axis” and it will kinda minimize, allowing you to go to your spreadsheet and simply highlight everything you want as a series as your X-values (for example, 1 to 4). If it automatically selects something for you, just click remove to get rid of everything, and then click "Add"to create a series. In the chart wizard, once you’ve selected the type of graph you want, click on the "series"tab. Then you can make the 1-4 points as one series on the graph, and the other two as another. One way to do it for sure is to make the points that you don’t want as a different series…For example, if you have something like this: Once you’ve done that, right click and select trendline…it might work. Select a single one (the first one at one end) and hold control while you select the other ones that you want to inclue. I don’t have Excel available to fiddle with right now, but you should be able to select only particular spots on your grapht.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |