LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
maperalia
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically update chart plotting current month and previous 6 Jane Charts and Charting in Excel 1 September 1st 05 10:19 PM
Update Chart Macro Sal Charts and Charting in Excel 0 August 28th 05 11:21 PM
How do I automatically update a chart range in Excel Quinton Excel Discussion (Misc queries) 1 July 27th 05 12:57 PM
Macro to Update Chart ddng Charts and Charting in Excel 1 February 18th 05 11:41 PM
How do I automatically update chart source data links for moved fi Suzuki7 Charts and Charting in Excel 2 February 15th 05 03:55 AM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"