Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

How to Dynamically Change Excel Chart Data

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,757
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 15, 2010

You can quickly change the data that your Excel Chart displays by choosing a scenario from a list in a Combo Box.

Of course, the cell link for your combo box needs to be referred to in a formula that "drives" your data.

Watch how I use the INDEX Function to look up the values for the chart data, In my example, the Row Number in the formula references the cell that links to the Combo Box.

It is easier to watch how this is done than to read about how to do it - in my opinion.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - View all of the resources that I offer.

I welcome your feedback, please add your comments below.

Danny Rocks
The Company Rocks

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (DannyRocksExcels)

  • Excellant! Thanks Danny. Very helpful!

  • @cloudofwhite

    Thank you for your kind words. I am happy that I could help you.

    I appreciate you taking the time to add your comments.

    Danny Rocks

    The Company Rocks

  • Amazing tutorial

  • @TheDobby100

    Thank you! I am pleased that you enjoyed my video tutorial. Thanks for adding your comment!

    Danny Rocks

    The Company Rocks

  • @TheDobby100

    Thank you for your kind comment. I am pleased that you enjoyed my video tutorial.

    Danny Rocks

    The Company Rocks

  • excellent tutorial. cheers :)

  • @clockworkmunkee

    Thanks for your comments. It is my pleasure to help my viewers to learn more about the "ins and outs" of Excel.

    All best wishes,

    Danny Rocks

    The Company Rocks

see all

All Comments (9)

Sign In or Sign Up now to post a comment!
  • @Paulos17777

    I am pleased that I could help you out with this video lesson. Thank you for wrting to tell me.

    Sincerely,

    Danny Rocks

    The Company Rocks

  • Awesome! Thanks for the useful video. Helped me out a treat! :)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more