You can “drive” your Excel Charts – dynamically change the data behind the chart. Focus your audience’s attention on the information that you are discussing. Let your audience see a chart that illustrates the scenario that they select.
To do this – add a Combo Box that lists the choices for each chart display that you offer!
(Click here to view my free Excel Training lesson on Combo Box Controls for more information.)
Key Steps to Take:
- Use the INDEX() Function to look-up the values for your chart data.
- For the 2nd argument in the INDEX() Function select the cell that is the “cell link” for your Combo Box. Use the F4 Keyboard Shortcut to make this part of the formula “Absolute.”
- Insert the Chart Type that best represents your data. Position your chart adjacent to the Combo Box.
Click here to watch this video on my YouTube Channel – DannyRocksExcels – in High Definition and Full Screen Mode.
I have several lessons that cover Charting in Excel 2007 on my DVD, “The 50 Best Tips for Excel 2007.” Buy it now!
Learn to “Master Excel in Minutes – Not Months!”
Use a Combo Box to Dynamically Change Your Excel Chart Data [ 6:53 ] Play Now | Play in Popup | Download (1407)Link to this post!
Speak Your Mind