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

[@almualvarez5130]

love from Vincent :)

[@mujtabashareef8712]

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

[@BethwellMutai]

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

[@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?

[@crumblebearmutch4335]

Thank you very much Karina. Your method is brilliant

[@yuvalste]

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

[@wanaliff7125]

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

[@julielyu7742]

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

[@christianchayna9634]

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

[@sanjeevs7504]

Great, Thanks for such wonderful video

[@valeriyafrolova6263]

you are the best!!! THank you!

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

[@MdFahim-uf1bj]

Karina you are really great!

[@talharazaulla8729]

This is INCREDIBLE!

[@patrickdkinuthia2160]

Thank you...

[@eng.hafizhabibhabib1268]

Very good

[@vincentstalmans6174]

love from Almu :)

[@MrDaffydGriffiths]

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

[@administrativeassistant-co6985]

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

[@charlesg5468]

Thank you so much :) God bless!