![]() ![]() In Excel 20, select the scatter chat, and click the Layout > Error Bars > More Error Bars Options.In Excel 2013, select the scatter chart, and click the Design > Add Chart Element > Error Bars > More Error Bars Options. ![]() Step 4: Add error bars for the scatter chart: (4) Click both OK buttons to close two dialog boxes. (3) Specify the Range E2:E14 in Height column as the Y values in the Series Y values box (2) Specify the Range F2:F14 in Axis column as the X values in the Series X values box (1) In the Series name box enter a name for this series, such as Timeline Step 3: In the opening Select Data Source dialog box, click the Add button. Step2: Right click the blank chart, and select the Select Data from the right-clicking menu. Step 1: Don’t select any content in the table, and click the Insert > Scatter (or I nsert Scatter(X, Y) or Bubble Chart button in Excel 2013)> Scatter. And this part will walk you through creating a timeline/milestone chart in Excel. With the first part we have prepared a table (see screen shot above) for timeline/milestone chart creating.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |