Dynamically Control Excel Chart Trend Lines with Check Boxes and Drop-Down Lists

Excel

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.

Adding the check box and drop-down gives your Excel dashboard user full control.

Adding the check box and drop-down gives your Excel dashboard user full control.

Prior Excel dashboard tutorials explain how to create each of these techniques.

To see how to control the show/hide of data, click here.

Using a Check Box to Dynamically Show or Hide Trend Lines in Excel Charts

To see how to control which trend line is used, click here

Use a Drop-Down List and INDEX to Dynamically Select a Trend Type in Excel Charts

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 select between different TREND lines with a drop-down menu.

Learn how to edit a TREND or array function.

Share the power...