Changing the order of the categories for each data set in a stacked bar chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2676228%22%20slang%3D%22en-US%22%3EChanging%20the%20order%20of%20the%20categories%20for%20each%20data%20set%20in%20a%20stacked%20bar%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2676228%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20change%20the%20order%20of%20the%20categories%20across%20each%20session%20date.%20For%20example%3A%20session%2016%20P1%20named%203%20dishes%2C%20then%203%20appliances%2C%20then%203%20utensils%3B%20session%2017%20P1%20names%204%20appliances%2C%20then%203%20dishes%2C%20then%203%20utensils.%3C%2FP%3E%3CP%3EI%20need%20to%20indicate%20the%20order%20that%20the%20categories%20were%20presented%20and%20not%20just%20the%20number%20of%20items%20across%20categories.%20When%20I%20changed%20the%20order%20of%20the%20categories%20it%20changes%20the%20order%20across%20every%20data%20set%20and%20not%20just%20one%20session.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2676228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2676648%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20the%20order%20of%20the%20categories%20for%20each%20data%20set%20in%20a%20stacked%20bar%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2676648%22%20slang%3D%22en-US%22%3EYou%20need%20to%20add%20the%20sessions%20or%20dates%20as%20another%20column%20in%20the%20data%20table.%20And%20then%20get%20rid%20of%20the%20blank%20rows.%20Or%20the%20other%20way%20around.%20But%20both%20of%20those%20steps%20are%20needed%20to%20make%20this%20a%20coherent%20and%20well-designed%20table%20of%20data%20which%20can%20then%20be%20graphed%20in%20a%20variety%20of%20ways.%3C%2FLINGO-BODY%3E
Visitor

I am trying to change the order of the categories across each session date. For example: session 16 P1 named 3 dishes, then 3 appliances, then 3 utensils; session 17 P1 names 4 appliances, then 3 dishes, then 3 utensils.

I need to indicate the order that the categories were presented and not just the number of items across categories. When I changed the order of the categories it changes the order across every data set and not just one session.

Is this possible?

1 Reply
You need to add the sessions or dates as another column in the data table. And then get rid of the blank rows. Or the other way around. But both of those steps are needed to make this a coherent and well-designed table of data which can then be graphed in a variety of ways.