I have a dataset with a column called Products with five types of products, from which I only need to represent three in a stacked bar chart. (Those products are shirts, shoes and dresses)
I also have five columns Q1,Q2,Q3 , Q4 and total yearly
The stacked bar chart should have in the x axis the Q1, Q2, Q3 Q4 and total yearly, and in the barst the three types of clothing should be represented.
As far as I know, I need to pivot or unpivot those three columns? Something related to taking the resident table?
I am a little lost and i would appreciate any help..
attached u will find a pic of what i need, the quality of the drawing is not good, but i guess u get the idea 🙂
