Excel Magic Trick #230: Dynamic Stock Chart Excel Table List

This item was filled under [ Stock Charts ]

See how to use the Excel List Table feature to make a dynamic Stock Price Line Chart. Excel 2003 create a List use Ctrl + L. Then the ranges in the table are dynamic. Excel 2007 create a Table use Ctrl + T Then the ranges in the table are dynamic.

Tags: , , , , , , , ,
Tagged with: [ , , , , , , , ]
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

16 Comments on “Excel Magic Trick #230: Dynamic Stock Chart Excel Table List”

  • ExcelIsFun
    14 May, 2011, 14:02

    I have not. Sorry.

  • enigmaman55
    14 May, 2011, 14:36

    Have you ever developed a Point and Figure program that would operate in excel 2003? IM interested in learning but have not found any resource but yours that I feel would be helpful to that end

  • ExcelIsFun
    14 May, 2011, 15:17

    I don’t know. You should post your question to the Mr Excel Message Board:


    Smartest Excel people hang out at that site.

  • amberkarkauskas
    14 May, 2011, 16:10

    How would you hide axis labels if your cells have nothing in them? I want to have dynamic chart that would update automatically with a new data dump. As you shown in a first example I have many future months as empty cells that will be filled later. How can I create a chart that would dynamically display only cells that have value in them?

  • ExcelIsFun
    14 May, 2011, 16:30

    You are welcome!

  • woodpusha954
    14 May, 2011, 16:35

    This helped a lot, thank you.

  • ExcelIsFun
    14 May, 2011, 16:47

    You are welcome!

  • badano13
    14 May, 2011, 17:15


  • ExcelIsFun
    14 May, 2011, 17:35

    I don’t know what you mean by ‘tab hit’. If you are asking if the List feature with dynamic ranges and with using the tab key in the last row to add a new record is in 2003. The answer is yes.

  • 1itzik
    14 May, 2011, 17:58

    thank yuo for all your videos!!!!!!
    is the tab hit work in 2003?

  • ExcelIsFun
    14 May, 2011, 18:20

    Dear lickensiedickenburg,

    You are welcome!


  • lickensiedickenburg
    14 May, 2011, 19:16

    thanks a lot!

  • ExcelIsFun
    14 May, 2011, 19:32

    Dear Dave51262,

    You are welcome! I am glad that you like them. I do not know about professional, though – I get many complaints about how I talk (spitting into mic and too enthusiastic and other stuff). But those people are looking a gift-horse in the mouth!


  • Dave51262
    14 May, 2011, 19:51

    Your videos are awesome and so practical! Each one is high quality content and very professionally done. Thanks a lot for these!

  • ExcelIsFun
    14 May, 2011, 19:57

    Dear a12436,

    Not right a way, but later, I will make a video about the waterfall chart. The learn Excel From Mr Excel book (page 628 in the Excel 2003 book) have a great example of this.


  • a12436
    14 May, 2011, 20:49

    So cool! Thanks a lot!

    Can u spend a few minutes to explain how to make a “waterfall” chart?

Leave a Comment