How to show trend using data from two tables

[PowerBeeEye]

I have two tables The first shows data from last year:

The second shows data from this year:

I would like to plot a trend using the department as a filter like so:

Can someone give me pointers on how to achieve this?

[MFelix · Accepted solution]

Hi @PowerBeeEye,

I think that the best option is to append both tables into a single one, unpivot the columns of the groups and then create your chart from that.

Regards,
MFelix

[PowerBeeEye]

@MFelix 

Thank you, unpivoting and combining the tables really helped.I'm using the stacked column chart, and for some reason I can't change the Y axis to show abolute numbers and not percentage.

Also, is there a way to both show the absolutely numbers and percentage change?

[PowerBeeEye]

turns out the type had to be changed to whole number for that column