Use sparklines to show data trends - Microsoft Support
Learn how to use sparklines to show data trends and visually represent your data within a cell of an Excel worksheet.
Add a trend or moving average line to a chart - Microsoft Support
Formatting a trendline is a statistical way to measure data: Set a value in the Forward and Backward fields to project your data into the future. Add a moving average line. You can format your trendline to a moving average line. Click anywhere in the chart.
Analyze trends in data using sparklines - Microsoft Support
Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color.
TREND function - Microsoft Support
The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that line for the array of new_x's that you specify.
Create a forecast in Excel for Windows - Microsoft Support
When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.
Use the Analysis ToolPak to perform complex data analysis
A moving average provides trend information that a simple average of all historical data would mask. Use this tool to forecast sales, inventory, or other trends. Each forecast value is based on the following formula.
Project values in a series - Microsoft Support
You can use Excel to project values that are based on existing data or to automatically generate values based on linear or growth trend calculations. Fill in a series that fits a simple trend, use functions to extend complex and nonlinear data, or perform regression analysis with the Analysis ToolPak Add-in.
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Analyze Data in Excel - Microsoft Support
Trend: Highlights when there is a steady trend pattern over a time series of data. Outlier : Highlights outliers in time series. Majority : Finds cases where a majority of a total value can be attributed to a single factor.
Key Performance Indicators (KPIs) in Power Pivot
Key performance indicators (KPIs) are visual measures of performance. Supported by a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of a metric against a defined target.
Add a legend to a chart - Microsoft Support
Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.