Using Excel Controls to Change Chart Data

In this movie I demonstrate how to use controls from the Forms toolbar to change the data in a chart on the fly. Please visit http://www.TVMCalcs.com/ for more useful tutorials.

Category:

Howto & Style

Tags:

• Microsoft
• Excel
• controls
• charts
• data
• TVMCalcs.com
• drmayes

[xxxericbxxx]

this is one of the best dynamic charting tutorial i've seen here in youtube. thank you for sharing your knowledge doc! those 14,500+ people who viewed your tutorial are still hungry for more! please post some more tutorials! thank you very much!

[LincolnHo]

Thank you. I understand this video and was able to duplicate this! Now, is there a way to "offset" by spreadsheet so that each drop down option will select the data from the next spreadsheet over each time you go down? For example, if my dropdown contains 1,2,3,4,5, 1 would reference cell A1 on spreadsheet 1, 2 would refer to cell A1 on spreadsheet 2, 3 would refer to spreadsheet 3, etc...

[LincolnHo]

Thank you. I understand this video and was able to duplicate this! Now, is there a way to "offset" by spreadsheet so that each drop down option will select the data from the next spreadsheet each time you go down?

[richardkinzer]

Dr Mayes, I've visited your website and it's great. Sure hope you find the time to put some of that content here in video form.  You have some of the best "Real World" Excel applications on youtube. Thanks for your contributions.

[JimBag100]

Outstanding!  Thank you.

[lancer107]

Excellent - very useful. Thank you.

[LotfyKozman]

Dr. Why did you stop? This is one of the great videos I have watched. Please continue to fill out thirsty. Thanks so much and God blesses you.

[Ticoguim]

Great video and explanation..thanks!!!

[lexdante]

good

[supermansecrets]

great example! hope to see more of it....