Creating one chart from 2 tables

[rollerdyke44]

Hi

I need some help as i am a novice in excel. Here are two tables that represent key stats from 2 companies profit statement over 3 years.

http://s16.postimg.org/8h9y88mx1/image.png

Now what i want to do is make one (bar) chart which compares both elements ("Net interest before income" and "Net interest after income") for the 3 years for both companies


i am able to make the charts seperately, but how do i make one chart

http://s8.postimg.org/olqhcry6d/image.png


thanks

[smb_146]

Creating One Chart from 2 different tables isn't recommended because you'll have to do lots of manual adjustments.

I've created 2 charts
one as per your requirement (and a little modification)

and another one for which I've re-arranged the data.

For details check the attachment.

[rollerdyke44]

Creating One Chart from 2 different tables isn't recommended because you'll have to do lots of manual adjustments.

I've created 2 charts
one as per your requirement (and a little modification)

and another one for which I've re-arranged the data.

For details check the attachment.

hey thank you so much for your help

[smb_146]

you're welcome dear