+ Reply to Thread
Results 1 to 3 of 3

Macro to Update Chart

  1. #1
    Registered User
    Join Date
    02-16-2005
    Posts
    3

    Macro to Update Chart

    I have data that I want to draw a line chart too. When I change the data I want to see the changes in the chart. Can some one point me in the right direction of simple charting and macro's?

  2. #2
    Tushar Mehta
    Guest

    Re: Macro to Update Chart

    Select the data range then click the ChartWizard button on the toolbar.
    Follow directions to create the kind of chart you want.

    When you change the data in the range you plotted, the chart will
    automatically update.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <ddng.1knxuf@excelforum-nospam.com>, ddng.1knxuf@excelforum-
    nospam.com says...
    >
    > I have data that I want to draw a line chart too. When I change the
    > data I want to see the changes in the chart. Can some one point me in
    > the right direction of simple charting and macro's?
    >
    >
    > --
    > ddng
    > ------------------------------------------------------------------------
    > ddng's Profile: http://www.excelforum.com/member.php...o&userid=20031
    > View this thread: http://www.excelforum.com/showthread...hreadid=346867
    >
    >


  3. #3
    Registered User
    Join Date
    02-16-2005
    Posts
    3

    Macro - line chart?

    Thanks, I am trying to draw a customized line chart that looks something like below(in black). Excel doesn't seem to have a function that draws charts like this relative to time(dates). Does anyone know any techniques I could use to be able to draw charts like below with a macro?

    ___________________
    ___________|
    _____|

    Jan.....Feb.......... April...........May

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1