USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
change the chart type to the line with a trendline
|
|
|
right-click a data series and then select Add Trendline on the shortcut menu.
|
|
|
select the trendline style in the chart styles gallery on the Chart Tools Design tab.
|
|
|
use the Insert Shapes tool on the Chart Tools Format tab to draw a trendline on the chart.
|
Detailed explanation-1: -Once we have the chart inserted in the PowerPoint slide, we can right click to display the popup menu and click Add Trendline. This option will display a new dialog box where you can configure the moving average line or trendline. The line will be added to the existing PowerPoint chart to show the trend.
Detailed explanation-2: -Linear trend line Use this type of trendline to create a best-fit straight line for simple linear data sets. Your data is linear if the pattern in its data points looks like a line. A linear trendline usually shows that something is increasing or decreasing at a steady rate.
Detailed explanation-3: -Select the data that you want to plot in the line chart. Click the Insert tab, and then click Insert Line or Area Chart. Click Line with Markers. Click the chart area of the chart to display the Design and Format tabs.