You can get very creative using check boxes and drop down lists to give users the ability to view different sets of data and trend analysis. In this example the user can use a check box to select whether to show or hide the trend line. They can also use the drop down list to select between a linear (TREND) or exponential (GROWTH) trend line.
Prior Excel dashboard tutorials explain how to create each of these techniques.
To see how to control the show/hide of data, click here.
To see how to control which trend line is used, click here
You can download the Excel workbook containing these dynamic trend line charts here. Dynamic Trend Charts – Advanced.
Learn how to extend a TREND line to create a forecast.
Learn how to show or hide a TREND line under the check box control.
Learn how to edit a TREND or array function.