Firstly, although I've used After Effects rather a lot, it has been for one-off projects and I only use it when I need to, therefore my technical knowledge and after effects vocabulary aren't great. I always try to work out how to do things myself but I'm just completely stuck on this.
I have an animation that represents, layer by layer, the rise in global population from the year 1712 to present day. TO accompany that animation I would like a counter that displays the year and the population value, changing year-by-year, frame-by-frame over 304 frames. I have the values as lists in Excel, the text separated by line returns.
I could use the slider control to alter the year value, but the population value does not increase in a linear fashion and therefore needs to precisely follow the values in the Excel list.
I thought I'd found a solution in the DecomposeText script but it took over an hour to run and left me with 100s of Frames, making the project very difficult and slow to work with. As I need to do this for at least 5 similar animations, it's not really feasible.
Excuse my extremely wordy first-ever post, any help is much appreciated!
on Nov 18, 2017 at 7:22:06 pm Last Edited By Liran Tabib on Nov 18, 2017 at 7:26:26 pm
You have a lot of options to create a counter animation in After Effects:
1. The native text->Numbers effect.
2. Connecting the source text property to a slider which drives the number animation (using Math.round() will help)
3. Counter Preset for after effects to save all the hassle and limitations of other methods.
It seems that you need to utilize the new feature in 2018 to import data from excel to create the animation directly so you wont need to animate 304 keyframes...