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

[@julielyu7742]

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

[@crumblebearmutch4335]

Thank you very much Karina. Your method is brilliant

[@wanaliff7125]

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

[@christianchayna9634]

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

[@talharazaulla8729]

This is INCREDIBLE!

[@sanjeevs7504]

Great, Thanks for such wonderful video

[@valeriyafrolova6263]

you are the best!!! THank you!

[@yuvalste]

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

[@MdFahim-uf1bj]

Karina you are really great!

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

[@patrickdkinuthia2160]

Thank you...

[@user-wx2vr5cl7r]

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

[@almualvarez5130]

love from Vincent :)

[@mujtabashareef8712]

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

[@eng.hafizhabibhabib1268]

Very good

[@administrativeassistant-co6985]

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

[@MrDaffydGriffiths]

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

[@charlesg5468]

Thank you so much :) God bless!

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