Create Panel Line Charts (Video 1)

How to create a panel chart (or also known as a trellis chart). The idea follows the Edward Tufte concept of "small multiples" where multi-variate data is shown in a grid of smaller charts. It is a good way to show a comparison of data that have a similar time period.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@excelisfun]

Very EXCELlent video!!

[@stevesullivan457]

Nicely done, Doug

[@ragsanoor]

Thank you very much... really useful in presentation of data

[@stevennye5075]

very useful!

[@DougHExcel]

Hi Steven Nye, glad you liked it, thanks for commenting!

[@khalidmajeed2886]

sir how i make a separator column.

[@shikharajbhandari2229]

very helpful tutorial. Can you please teach how to animate chart in excel??

[@DougHExcel]

if you're referring to same type of capability like PowerPoint, there's not really that feature. There are some charts that can be animated via VBA (kzbin.info/www/bejne/pqWZXn6mbrGlmK8) or using Power Query (kzbin.info/www/bejne/a5u6iHRjoduZh68) like the bubble chart. Another option is to bring the chart into PowerPoint and animate it (kzbin.info/www/bejne/gJaUfGOmmM6CqK8)

[@rifelr8174]

awesome,.... thanks for sharing.. I have a bit problem how to create trend line for each state? I have the spread sheet data,... may I know your email? I will send it... thanks for help

[@DougHExcel]

Hi rifel fix, sorry 🙁....but try a post on the mrexcel.com forum!