Make an Excel dynamic chart using the form +index function

make an Excel dynamic chart using the form +index function

Preview

The dynamic chart is usually a function formula with the form control to complete, the following together to make it.

Material: a monthly sales report

Production steps:

1, add the auxiliary table and set the formula

Formula:

=index (c3:g3,c$9)

2, according to the auxiliary table to add a chart

3, Add Drop-down selection box.

Development tool-Insert-click the combo box and drop it onto the top of the chart.

(EXCEL2010 Development Tools Tab Add Method: File-Options-Custom ribbon-Select development tools, Excel2007 in the common use of option windows)

4, set the content of the fill and linked cells.

In the K-column enter January, February. The data source area selects the range. Cell links Select C9, and in the future when you select the Drop-down box, the selected number is entered into the C9 (select the first few options to enter a number).

Once the settings are complete, you can implement the dynamic chart effect at the beginning of this article.