|averages in excel graph||0.69||1||421||28|
Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right. Click on the "Insert" tab. Select "Line graph" and choose "2-D Line.".How to chart Text Trends in Excel?
Method 2 of 2: On Mac Open your Excel workbook. Double-click the Excel workbook document in which your data is stored. ... Select the data in your graph. Click the series of data that you want to analyze to select it. ... Click the Chart Design tab. It's at the top of the Excel window. Click Add Chart Element. ... Select Trendline. ... Select a trendline option. ... Save your changes. ...