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, Jul 16, 2013
    #1
    1. Advertisements

Ask a Question

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.