Hello everyone,
I'm not sure what I want to create is possible. But I would really need this type of chart.
I have some products that are produced in different countries. They have individual costs, 3 different ones, and they are updated quarterly. I want to display the trend over time and have the different costs be stacked on top of eachother, forming one column, symbolizing the total cost for that product in that country. (And then be able to compare countries / products w one another etc.)
I'm stuck as I can't find a way to seperate the costs per quarter. The costs for alla quarters just stack up as one pile. I want Q1's 3 costs to form one column (seperated by color), next to it comes Q2 and then Q3.
My data set is very big. And I can't change the design of my source data too much. But is there some way I can get this to happen?
Thank you!
Emma
Bookmarks