![]() ![]() ![]() Your graph should now look like the figure opposite. Leave the Series Name blank and click OK (twice). Select the remaining Series X values and Series Y values (in this case A7- A13 and B7- B13 respectively). In the Select Data Source window click Add. ![]() Leave the box next to Series Name blank and click OK. the first 5 data points):Ĭlick on the graph, then click the Design tab under Chart Tools.Ĭlick on the Select Data icon, then select Series 1 and then click Edit.Ĭlick the box under Series X Values and then highlight cells containing the first 5 x-values (in this case A2 to A6).Ĭlick the box under Series Y Values and then highlight cells containing the first 5 y-values (in this case B2 to B6). To only analyse and add a trendline to the initial rise in profit (i.e. Add Multiple Trendlines to a Graph ADD A TRENDLINE TO PART OF A GRAPHĮnter the data opposite onto Sheet4 and generate a graph so that your worksheet looks like the one displayed.PChem Teaching Lab | Excel 10 Using Excel 2010 - Add a Trendline to part of a Graph ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |