Dynamic graph

Discussion in 'Excel Charting' started by johnwyard, Jul 16, 2013.

  1. johnwyard

    johnwyard Guest

    I download stock market data into excel 7. I create a graph by selectin
    the data and using the line graph function.

    The amount of data is set by 2 date parms , a start and an end date
    Usually this graphs fine, but on occasion pulling data larger than th
    amount used to create the graph truncates data in the graph.

    These scripts are run 5 times a month.

    How do I create a graph that will dynamically adjust to the amount o
    data I download? Downloading smaller sets of data is ok, it is th
    larger downloads
    that sometimes force me to recreate the graph.

    Any hints/fix will be appreciated, John Yar


    --
    johnwyard
     
    johnwyard, Jul 16, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. LLC

    Half Bar Graph / Half Stack Graph ??

    LLC, Jul 8, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    211
  2. coal_miner
    Replies:
    4
    Views:
    188
    coal_miner
    Jun 3, 2005
  3. Jim Smith
    Replies:
    2
    Views:
    159
    Jon Peltier
    Jun 8, 2005
  4. MikeR-Oz

    Bar graph and line graph overlayed

    MikeR-Oz, Jan 2, 2006, in forum: Excel Charting
    Replies:
    4
    Views:
    183
    MikeR-Oz
    Feb 6, 2006
  5. Sanjay Kumar Singh
    Replies:
    1
    Views:
    350
    Tushar Mehta
    Jan 3, 2006
  6. Need Help 123

    Value displayed on graph is wrong- but graph is right?

    Need Help 123, Jan 18, 2006, in forum: Excel Charting
    Replies:
    0
    Views:
    113
    Need Help 123
    Jan 18, 2006
  7. Replies:
    2
    Views:
    265
  8. TerenYoung
    Replies:
    1
    Views:
    170
    Andy Pope
    Jun 15, 2006
Loading...