+ Reply to Thread
Results 1 to 3 of 3

Macro to Create a Chart and Update it Automatically

  1. #1
    maperalia
    Guest

    Macro to Create a Chart and Update it Automatically

    I wonder if you can help me to create a macro to make a chart and update it
    automatically when I add more information in the following rows.

    Basically, this is the table a have (see below) and I just want the column
    C and the column E have a chart. Where the column C is the x axis and
    the column E is the y axis.

    I have created manually already but I have the go to source data to update
    the chart every time I have more information in the following rows. Since, I
    have several tables that make it difficult to me to handle it easily.

    Thanks in advance.
    Maperalia


    A B C D E
    6/7/05 0 1611.112 0
    6/21/05 20160 141.986 1611.115 0.003
    7/6/05 41760 204.353 1611.11 -0.002
    7/22/05 64800 254.558 1611.112 0.000
    8/1/05 79200 281.425 1611.108 -0.004
    8/9/05 90720 301.198 1611.116 0.004
    8/30/05 120960 347.793 1611.101 -0.011
    9/6/05 131040 361.994 1611.111 -0.001
    9/15/05 144000 379.473 1611.107 -0.005
    9/22/05 154080 392.530 1611.123 0.011
    9/30/05 165600 406.940 1611.122 0.010
    10/7/05 175680 419.142 1611.123 0.011



  2. #2
    Andy Pope
    Guest

    Re: Macro to Create a Chart and Update it Automatically

    Hi,

    Have a look at this example of using named ranges to create dynamic charts.
    http://peltiertech.com/Excel/Charts/...umnChart1.html

    Cheers
    Andy

    maperalia wrote:
    > I wonder if you can help me to create a macro to make a chart and update it
    > automatically when I add more information in the following rows.
    >
    > Basically, this is the table a have (see below) and I just want the column
    > “C” and the column “E” have a chart. Where the column “C” is the “x” axis and
    > the column “E” is the “y” axis.
    >
    > I have created manually already but I have the go to source data to update
    > the chart every time I have more information in the following rows. Since, I
    > have several tables that make it difficult to me to handle it easily.
    >
    > Thanks in advance.
    > Maperalia
    >
    >
    > A B C D E
    > 6/7/05 0 1611.112 0
    > 6/21/05 20160 141.986 1611.115 0.003
    > 7/6/05 41760 204.353 1611.11 -0.002
    > 7/22/05 64800 254.558 1611.112 0.000
    > 8/1/05 79200 281.425 1611.108 -0.004
    > 8/9/05 90720 301.198 1611.116 0.004
    > 8/30/05 120960 347.793 1611.101 -0.011
    > 9/6/05 131040 361.994 1611.111 -0.001
    > 9/15/05 144000 379.473 1611.107 -0.005
    > 9/22/05 154080 392.530 1611.123 0.011
    > 9/30/05 165600 406.940 1611.122 0.010
    > 10/7/05 175680 419.142 1611.123 0.011
    >
    >


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    maperalia
    Guest

    Re: Macro to Create a Chart and Update it Automatically

    Andy;
    Thank you for your valuable information you just sent me. I will check it
    and let you know if I have questions.

    Best regards.
    Maperalia


    "Andy Pope" wrote:

    > Hi,
    >
    > Have a look at this example of using named ranges to create dynamic charts.
    > http://peltiertech.com/Excel/Charts/...umnChart1.html
    >
    > Cheers
    > Andy
    >
    > maperalia wrote:
    > > I wonder if you can help me to create a macro to make a chart and update it
    > > automatically when I add more information in the following rows.
    > >
    > > Basically, this is the table a have (see below) and I just want the column
    > > “C” and the column “E” have a chart. Where the column “C” is the “x” axis and
    > > the column “E” is the “y” axis.
    > >
    > > I have created manually already but I have the go to source data to update
    > > the chart every time I have more information in the following rows. Since, I
    > > have several tables that make it difficult to me to handle it easily.
    > >
    > > Thanks in advance.
    > > Maperalia
    > >
    > >
    > > A B C D E
    > > 6/7/05 0 1611.112 0
    > > 6/21/05 20160 141.986 1611.115 0.003
    > > 7/6/05 41760 204.353 1611.11 -0.002
    > > 7/22/05 64800 254.558 1611.112 0.000
    > > 8/1/05 79200 281.425 1611.108 -0.004
    > > 8/9/05 90720 301.198 1611.116 0.004
    > > 8/30/05 120960 347.793 1611.101 -0.011
    > > 9/6/05 131040 361.994 1611.111 -0.001
    > > 9/15/05 144000 379.473 1611.107 -0.005
    > > 9/22/05 154080 392.530 1611.123 0.011
    > > 9/30/05 165600 406.940 1611.122 0.010
    > > 10/7/05 175680 419.142 1611.123 0.011
    > >
    > >

    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info
    >


+ 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