@emily@gentile thanks so much for creating this tutorial! It was super helpful. For anyone else that uses this tutorial if you are planning to explore this I found that AE doesn't like the adjustment layer references if you send your motion graphics to Media Encoder. Instead export it to the native AE render queue and export it from there. No errors or broken data chart animation.
Edit: If you're importing into Premiere, the CSV file MUST be included in the main/imported composition. Otherwise it does not include it, and pulls no values! // This video not only showed me exactly what I needed, it also taught me expressions in After Effects. We now have a fully customizable, resizable bar graph for the future! Thanks so much for this truly excellent and detailed walkthrough!
Absolutely outstanding, Emily. A very thoughtful tutorial. Loved your inclusion of the goals at the outset. Attention to detail was also great! My mother's name was Emily, btw.
Hey Emily very good tutorial. Is there a way to make these bars change alont the timeline according to this data? Lets say I have a demographic chart where bars should be changing along the years. Thanks!
hmm maybe you could connect to a slider control that controls which row or column your chart is looking at vs using the index? That way you could animate the slider, but it would require some coding to make a smooth transition between values. Just thought of this off the top of my head but I'm sure there are other solutions as well :)
Here's a couple of troubleshooting steps i suggest: first, when you drag your csv file into your timeline, does it show the column headers? If your csv is set up properly and the column headers show up properly, make sure you're referenceing the correct column with the numbers you want the bar graph to represent (perhaps you need to reference column 0 instead of column 1 for example?) Make sure there's no spaces after or in-between any of your numbers in your csv file. Line breaks are fine as you see in my video, but spaces inbetween characters can make things wonky. For example if my csv reads "1920 , 1000" in a row, the space after 1920 might mess with my data (same thing if there was space after the 1000) I hope you're able to figure it out!
I had the same problem, but I found that my CSV had commas in the numerical values which caused the problem (i.e. 1,987 rather than 1987). Removing these commas in my text editor and re-saving the CSV seemed to correct it :) hope this helps!
Thanks for your interest! I'm glad you found the tutorial helpful! I've posted the project files on my Gumroad account: emilyagentile.gumroad.com/l/CSVtoBarGraph
Hi ! Very nice tutorial🥰 How can i do to change the data value on a compositions? So i got a text and a shape that are responsive one to other in a comp, and i want to change the text value related with an excell as you show but from this comp not from the layer text , like that i can duplicate the comp with - 1 value everytime . it is possible¿?
Hi there! It sounds like you might want to utilize "thisComp.split()" to reference your excel sheet columns. For example "Comp Name - 0" would reference column 0. Duplicating this comp would give you "Comp Name - 1" refenceing the next column, etc. I'm making a tutorial about this topic soon!
Would you accept a zoom meeting to explain me the solution? I am a AE beginner... so far i am complete lost on how to make it work (even if you gave me some ideas) ^^