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