If you want to follow along, this basic chart will first be used to create an embedded trend line that shows in the chart without data on the worksheet. After that, we’ll go a lot farther. We’ll create trend data in the worksheet and a system of menus that allow your users to show or hide the trend line and select from different types of trend lines.
Download the basic trend worksheet here. Dynamic Trend Charts – Basic
This basic chart with dates in row 22 is used throughout the dynamic trend lines for Excel dashboards tutorial. Download the basic trend worksheet here. Dynamic Trend Charts – Basic
Tutorial Start > Excel Trends Tutorial: Creating Dynamic Trends on Charts