How to make a panel chart in excel - method 2

In this video I show you how to make a panel chart in excel. First add all the data to one chart. Secondly multiple/divide/add/subtract to get the data series to have the same range and to be evenly spaced out. Finally add in pretend axis using extra data series and add data labels to them to get the correct numbers.
--------------------------------------------------------------------------------
#exceltips #exceltutorial #excelcharts
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 1904
These data are related to my masters dissertation
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
How to make panel charts in excel - method 1 • How to make panel char...
How to make a correlation matrix using a website • How to make a correlat...
How to make dynamic charts in excel • How to make dynamic ch...

[@crumblebearmutch4335]

Thank you very much Karina. Your method is brilliant

[@BethwellMutai]

thanks for this informative tutorial. It becomes however troublesome for datasets whose x-axis are strings e.g., station names

[@julielyu7742]

thx for your video tutorial, I've learnt by watching your video and successfully carried out with my thesis plots!

[@administrativeassistant-co6985]

Truly professional! Expands the scope that MS could not show!

[@talharazaulla8729]

This is INCREDIBLE!

[@christianchayna9634]

YOUR VIDEO IS PRETTY AWESOME! THANK YOU VERY MUCH KARIN AD!!!

[@ydnah2]

Great stuff. You are so smart and do it beautifully. Thank you and I have learnt the new trick from you that I did not think it could even be possible.

[@wanaliff7125]

thank you for your tutorial, it really good and easy to understand. May God bless you always :)

[@yuvalste]

Great tutorial! I was wondering if you can also add shaded areas to such a chart?

[@MrDaffydGriffiths]

Outstanding tutorial, I'm going to get so much use out of this. Thank you!

[@almualvarez5130]

love from Vincent :)

[@mujtabashareef8712]

A very smart way to do this, do you have a template excel file?

[@MdFahim-uf1bj]

Karina you are really great!

[@valeriyafrolova6263]

you are the best!!! THank you!

[@sanjeevs7504]

Great, Thanks for such wonderful video

[@vincentstalmans6174]

love from Almu :)

[@venysusrianti9916]

I followed the tutorial you gave, but for the second axis, it always display on left side, how to make it shown on right side or become secondary axis?

[@charlesg5468]

Thank you so much :) God bless!

[@patrickdkinuthia2160]

Thank you...

[@eng.hafizhabibhabib1268]

Very good