Forum Discussion
Solved
How to show trend using data from two tables
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?
- 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
3 Replies
- 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,
MFelixThank 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?
turns out the type had to be changed to whole number for that column
