Method 2 … Go to the formula bar and type =. If you select headings with the data Excel will add the names to the chart automatically. ![]() Click the Pivot Chart button under the Insert tab. ![]() ![]() The x-axis of the graph gets updated with the year values, as shown below – The answer to “how to make a line graph in Excel 2013” or “how to make a line graph in Excel 2016” is the same!This method works across most versions of Excel … The simplest way to create a basic chart in Excel is to highlight the data that you want included in your chart and use either of the following keyboard shortcuts: Alt + F1 – if you want the chart on the same worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |