hi guys, i have a question about Excel charts, can someone plz help? i have the two data sets below. i want to combine it into one chart, where i show stacked bars for each of mortgages, Lines, and Prime Based across time but then on the same chart at the top i want to include two lines for Prime and BA. do you guys know if there's a way to do this? i know that one is quarterly and one is monthly so not sure how that would work. i know how to create each chart individually with different scales but not sure how to combine into one with the same scale but shows monthly movements for Prime BA. Thanks in advance!
i have one set of data that looks like this:
ASSETS Q4/17 Q1/18 Q2/18
Mortgage 47.2 46.4 45.8
Lines 34.5 34.6 34.9
Prime Based 17.1 17.3 17.6
then i have another set of data that looks like this:
Date Prime (%) BA (%)
Dec-17 3.2 1.404366667
Jan-18 3.2 1.462612903
Feb-18 3.312903226 1.632419355
Mar-18 3.45 1.6653125
Apr-18 3.45 1.698306452
i have one set of data that looks like this:
ASSETS Q4/17 Q1/18 Q2/18
Mortgage 47.2 46.4 45.8
Lines 34.5 34.6 34.9
Prime Based 17.1 17.3 17.6
then i have another set of data that looks like this:
Date Prime (%) BA (%)
Dec-17 3.2 1.404366667
Jan-18 3.2 1.462612903
Feb-18 3.312903226 1.632419355
Mar-18 3.45 1.6653125
Apr-18 3.45 1.698306452
