Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automate charting

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet recording daily stock price. I want to have a chart to reflect the price trend and I don't want to do the charting every time by hand. could anyone tell me how to automate charting with weekly or monthly data? could I use macro to draw the chart? and then weekly or monthly I could run the macro to create the chart? how?
    thanks a lot.

    [ This Message was edited by: joemark on 2002-04-02 23:27 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Joe


    You could create a dynamic named range and then drop your data straight into this range. This way you need not keep recreating charts.

    I have some samples of these great named ranges here:
    http://www.ozgrid.com/Excel/DynamicRanges.htm


    I also have some examples of charts that can alter automatically by Day, Week, Month or Year here: http://www.ozgrid.com/Excel/ChartTips.htm These are near the bottom under:
    "Two Handy Dynamic Ranges For Charts"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •