Creating an Excel Chart to Practice Trend Lines

Charts

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

Use this basic Excel data throughout the trend line tutorial.

Use this basic Excel data throughout the trend line tutorial.

 

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

 

Next > Creating a Simple Trend line on Your Excel Chart

Tutorial Start > Excel Trends Tutorial: Creating Dynamic Trends on Charts

Share the power...