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

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

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