PDA

View Full Version : Dynamic chart ??? VBA



Rmag
11-05-2012, 12:30 PM
Hi i want to make a dynamic chart but i am stuck....http://www.thecodecage.com/forumz/images/smilies/confused.gif i do not know how to make it work ???

Here is the file it will be easier to show what i wanna do then write all about it.....


ps pivot table is no good for me...

btw maybe someone knows how the vaule (red ) will change depends of rows in column 1 (date) (see file) INDEKS($B$1:$G$13;13;$L$3)


Any help would be great :)

Kenneth Hobs
11-05-2012, 01:24 PM
http://peltiertech.com/Excel/Charts/Dynamics.html