RYAN I need your help!
Posted by Norman on June 14, 2000 5:40 AM
Ryan,
On the 7/6 you gave a chap a URL. It was a zip file for auto-updating charts.
I really like it except I have many charts in my workbook. 2 charts to a sheet.
The problem is, is there a way to have the same effect chart i.e. auto-updating on every chart without the need to create new values in Name-Define.
My data is static, it will always start in the same places on each sheet (although differnt data). can they be linked?? or something.
Help me please.
Norman
Posted by Ryan on June 14, 0100 9:29 AM
I've never been one for charts, but I took a look at that file and it looks like the key thing is the formula he has entered in for the title of the Results column. The Text(Now(),"") makes the sheet volatile, which means it will update automatically. Also, for the ranges of data in the charts, you will just need to insert your data range for his and the trick is to add extra rows to allow for extra data that is inputed. Hope you have some luck, it doesn't look like a fun task. Let me know,
Ryan
