how Excel dynamic charts are made
Preview
The dynamic chart is usually the function formula with the form control to complete, the following with this article to make a simple Excel dynamic chart bar.
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, in the future when the Drop-down box selection, the selected number will be entered into the C9 (select the first few options to enter a number)