How to Make Pie Charts from Spreadsheets in After Effects

[@vultan2000]

Brilliant. There is so much to learn from this tutorial and it’s a generous project resource to make available. Thank you

[@8050026091]

Following the same steps, but at 5:55 after effects is throwing an error - " the expression result must be of dimension 4 not 1"

[@ErikvanRavenstein]

2:20 love the other tabs you have open .... black market antidepressants?

[@AndrewMarston]

┐( ∵ )┌

[@kiranakepakisan3260]

"Always label your layers" Me: yeah... Maybe next time

[@KowProdMedia]

Your browser tabs are interesting 😂 Nice content though 🤙

[@AndrewMarston]

Hahaha, I was wondering if someone would notice.

[@KowProdMedia]

@@AndrewMarston no judgements at all, it’s always interesting, it’s like a peek into someone’s world. I’m enjoying your content though, keep it up!

[@AndrewMarston]

@@KowProdMedia I actually put them there on purpose as a joke. I don't really care about view counts, only that the people who see the video get helpful info, so it was supposed to be a bit of tongue in cheek humor. Now I'm wondering how many people will think they are real. :-/

[@KowProdMedia]

@@AndrewMarston I couldn’t possibly care less. Good content with good information is good content with useful information. Keep up the good work 🤙

[@mattchandronait6618]

Stellar tutorial! I can't believe it took me hours of Googling to find it. Thank you immensely for taking the time to do this and upload it. I learned SO much!

[@jay20032009]

A little bit speedy, but amazing how it could be easy to handle with pie charts in AE. THX

[@hvntr]

Absolutely amazing! The idea behind this is very smart and I love the fact that one can use just pure data (as in csv) to run and create graphics. I'm already thinking how to implement this to bar charts that have absolute values and how to draw specific amount of horizontal lines for the graph based on the maximum value of the tallest or longest bar.

[@sergedruz7261]

Really nice tut, I like how you made animation, didn't see this before, multiplying on slider which goes from 0 to 1, really clever.

[@AndrewMarston]

Thanks Serge. I use this trick of multiplying values by a slider that's animating from 0 to 1 fairly often.

[@Pro_Data]

I've built something a little more complicated. If you want I can share so you can make a second part for this tutorial

[@AndrewMarston]

Thanks Gersi that's very generous. I would be interested to see your rig. Maybe easiest to use the contact form on UkraMedia.com and make sure to add something like "Attn: Andrew". Indeed this tutorial is just a starting point. I didn't want to overwhelm people who are new to some of the concepts, but also realized that expression gurus like yourself might be bored. Perhaps a follow-up video would be helpful. Looking forward to seeing what you came up with.

[@Pro_Data]

@@AndrewMarston well, I need to comment some code since its a mess right now and even I cannot understand what I've done 😂. But, basically, Its the same concept as yours except I've added labels and values around the chart connected by paths to the middle outer radius of each slice. Anyway, I will send you the project as soon as I comment it...

[@AndrewMarston]

@@Pro_DataHa! I actually had this same thing rigged so labels and slice values stuck to the center of each slice, but deleted it because I didn't want the tutorial take an hour. No worries if it's a pain to send your project, but if you do I would be curious to see how you ended up calculated the label positions.

[@writtenbywalsh]

Thank you! This is amazing. I'm looking to do something like this but also export as a MOGRT for Premiere Pro users. Possible? Follow-up video on this topic?

[@Lucidvein]

You pulled a "draw the rest of the owl" trick at the end there.. how do we do that cooler looking animation :D

[@DonTerrell]

Great video, but my brain hurts just listening to all the expressions. Lol

[@Arslanenok]

So smart, big thanks! AE is such a powerful tool.

[@justinvanderwaal3887]

I wish this came out sooner! I ended up spending 2 weeks on the internet to do this same thing. Not many people have good videos about this.

[@sachibbankib]

Very nice tutorial video

[@craigjcarroll]

When I go to import my Csv file that I export from google sheets it says it is damaged or unsupported. I've tried multiple times. Any ideas?

[@craigjcarroll]

Figured it out. I had commas in the cells. Deleting them fixed it.

[@ukramedia]

Glad you were able to figure it out. Thanks for watching the tutorial!

[@syedikramullah1114]

Superb

[@clementduval3917]

Is it a color palette on the left hand side of AE?!

[@AndrewMarston]

Yes, it's a plugin called Labels 3 on Aescripts, used for quickly changing layer label colors.

[@HumblyNeil]

Super cool thanks for sharing Andrew

[@AndrewMarston]

My pleasure Neil!

[@spiroskappos]

Awesome tutorial, great job! Thanks

[@avizmotiongrafix]

Amazing. Ukramedia has the solution to almost all of my AE expression problems.

[@faxnfaxinger6176]

great explanation, but what i would be interested in is how you did the styling of the final piechart based on the styleframe by tony agliata. Would you also create a vid of this process?

[@EddyTheDesigner]

This channel is a hidden gem! Found you guys through the Adobe Max tutorial which Sergei presented. Been binging all day! Can’t wait to use what i’ve learned at work.

[@rob6433]

Nice! I was just wondering though why, when you add the progress to the piechart-1 expression (14:15) you need to copy the expression and paste it to the different layers? Instead of duplicate piechart-1 like you did before when creating the expression? Or better said, why won't the progress animation work on all layers when you duplicate them?

[@1WillyDAVID]

Pretty cool, glad to know this is possible, thanks a lot Andrew!

[@AndrewMarston]

Glad to help William!

[@justinvanderwaal3887]

Does anyone know if there is a way to link it to a google sheet? Or link it to data on a website that auto updates?

[@lucaswaldron5448]

Awesome tutorial. Anybody in the comments know how to take this one step further and animate between two different columns of data in a csv spreadsheet? For example, let's say I want the first data point to be 15% of the pie at the first keyframe, but increase to 25% of the pie at the second keyframe (and all of the other data points would obviously be shifting, as well). If I have the data already baked into my csv, is there a way to easily keyframe this?

[@mindcheck2010]

Good question. May be it could be some kind of ‘linear’ or ‘ease’ expression that went from one columns value to another?

[@Mosizzle600]

Extremely helpful! Thanks

[@nonthai7961]

Thanks for sharing

[@ukramedia]

Thanks for watching!

[@rakmichal]

Love it! Thank you very much for such a great content!

[@bush9686]

Wooh, thanks;)

[@AndrewMarston]

Sure thing Bush :)

[@goranthoren5522]

Wow! I quit.

[@Naresh996]

So good to watch. But too much complicated

[@meucanalmix]

wow

[@madknac2978]

This is really good. Very complex. Thank you for doing it! Are there any courses on how to write expressions for After Effects?

[@mindcheck2010]

Check out ‘school of motion’

[@ghogarth]

Also: kzbin.info/www/bejne/nZrUc5VnmrCZo6c

[@PrizrakKD]

Thanks for the interesting lesson! But it can be done many times easier and faster. aescripts.com/graph-master/