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: https://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 https://youtu.be/DAUh2Xvxt3w
- How to make a correlation matrix using a website https://youtu.be/LpxI-XCGD4o
- How to make dynamic charts in excel https://youtu.be/DAwwLbAlDTs

Видео How to make a panel chart in excel - method 2 канала Karina Adcock