After Effects - Create an animated bar graph using Excel or Google Sheets

[@davidmair3517]

@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.

[@emilyagentile]

Thanks for sharing!

[@Techspin]

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!

[@craigwall6071]

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.

[@alansaga1973]

best video ever, i was trying to discover how to sync the excel data with After effects,thanks so much 👍👍👍👍👍👍

[@Netizen56]

Thanks for this! Would love more tutorials related to infographics for after effects.

[@gianluccacolangelo6543]

Thank you very much Emily! I often wonder how can I merge science and art and this is definitely one way. There is no turning back, thanks again.

[@gianluccacolangelo6543]

Can you recommend me where can I go deeper about animating data sets?

[@emilyagentile]

@@gianluccacolangelo6543 Ukramedia and BallerFX on KZbin have a lot of really good tutorials!

[@MichaelThomas2477]

This was a great tutorial!

[@magiettadetko1543]

Excellent content, thank you for posting it. Very well explained.

[@BlackSwanFinancial]

Very good explanation 👏. Thank you fit the video. The best I've seen on the topic

[@ignaciosagrario]

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!

[@emilyagentile]

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 :)

[@andrewoward]

Nice work Emily.

[@realcarljhonson]

Fantastic tutorial....it seems like i was watching watchmojo type of quality voiceover with great explanation. 🙂

[@HarisRehan-f8d]

I dont understand, it keeps returning the error "couldnt return a numeric value"

[@emilyagentile]

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!

[@olliegeorge132]

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!

[@BenjaminCurry]

Thank you so much for making this!!

[@ML-vh7nz]

hello! Congratulations on this great tutorial. Is there a chance to place a link to the after effects file you made? Thank you in advance.

[@emilyagentile]

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

[@newsnew4185]

Wow so beautiful!!

[@tomaskoeck]

This is awesome, super informative.

[@eldadmarkus]

Thank you! Great tutorial

[@SportData_ES]

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¿?

[@emilyagentile]

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!

[@SportData_ES]

@@emilyagentile thank you very much , i will try myself and waiting for your tut too :))

[@SportData_ES]

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) ^^

[@SportData_ES]

I pay you 💪

[@natureismyjam]

This is a FANTASTIC tutorial!! THANK YOU! New sub from me!

[@_istudywater]

Excellent video, thanks!

[@pradippokhrel2233]

How can we create racing bar graph which sorts according to data provided ? can you please help mam

[@emilyagentile]

Hi there! The data will sort based on your csv file. Whatever changes you make to your file will reflect in the bar graph

[@yadavpokhrel3770]

kzbin.info/www/bejne/hJ-Xk5x9f7iWqbc

[@yadavpokhrel3770]

How can we create this kind of animation but this should be data driven ? Can you help please.

[@jlagerholm]

Thank you.

[@aliciajoohee]

thankssss

[@salahhammam438]

👌💯💯💯

[@mediocreape]

wow!!! thanks!