-
Dynamic values to control point chart
Hello,
I’m working on creating a series of dynamic chart elements for a project for a client. I’m using Templater form DataClay to dynamically pull data form a google sheet. Everything is working on the data pull side, but the problem I’m facing at the moment is, I want each dot to begin at a certain value on keyframe 1, then animate to the dynamic value in keyframe 2.
I’m really lost here. I’ve included the expression on the null layer controlling dot one, along with paired down project file with Templater removed. Manually changing the “S-point-1-DynamicText” layer will update y value for first dot within the range specified in my expression.
Any help will be greatly appreciated.
(apologies if it’s a little presumptuous to upload the project file ☺ )
12727_dynamicchartreduced.aep.zip
min = 0;
max = thisComp.layer("S-point-1-Display_Ctrl").effect("Slider Control")("Slider")+100;
val_num = thisComp.layer("S-point-1-Display_Ctrl").effect("Slider Control")("Slider");
if(numKeys > 1){
ease(time,key(1).time,key(2).time,min,val_num);}
[value[0], val_num];max_movement = -600;
newBaseLine = 881;
myYheight = ((val_num - min) / max) * max_movement +newBaseLine;
[value[0],myYheight]