What's the best way to visualize this data?

%3CLINGO-SUB%20id%3D%22lingo-sub-2047182%22%20slang%3D%22en-US%22%3EWhat's%20the%20best%20way%20to%20visualize%20this%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047182%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tracked%20my%20mood%20and%20habits%20over%20the%20past%20year%3A%3CBR%20%2F%3E%3CBR%20%2F%3EMood%20has%20been%20visualized%20as%20follows%20(1-5%2C%205%20being%20best%2C%20tracked%20daily%2C%20averaged%20out%20over%20month)%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mood.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245151iDA653D246CE9B5E5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mood.JPG%22%20alt%3D%22mood.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245148i41B61E45E338B418%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%221.JPG%22%20alt%3D%221.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHabits%20have%20been%20tracked%20as%20follows%2C%20just%20not%20sure%20how%20I%20would%20visualize%20this%20in%20a%20chart%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22fffff.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F245149i1824CF8E30533214%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22fffff.JPG%22%20alt%3D%22fffff.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20there%20be%20any%20way%20to%20cross%20reference%20the%20mood%20vs%20habits%20in%20a%20chart%20as%20well%3F%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2047182%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2047283%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20the%20best%20way%20to%20visualize%20this%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2047283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F924042%22%20target%3D%22_blank%22%3E%40May_Triggson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Excel%20Pivot%20Table%20is%20made%20for%20cross-tabulating%20things%20like%20that.%20You'd%20find%20it%20a%20lot%20easier%2C%20however%2C%20if%20you%20collected%20the%20two%20sets%20of%20data%20in%20a%20single%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20personally%20recommend%20expanding%20the%20number%20of%20columns%20in%20that%20first%20table%20to%20show%20which%20behavior%20(some%20clearly%20are%20%22habits%22%20but%20others%20are%20less%20so%3B%20%22behaviors%22%20strikes%20me%20as%20the%20more%20inclusive%20term%20for%20them%20all...anyway%2C%20create%20a%20separate%20column%20for%20each%2C%20and%20maybe%20even%20consider%20categorizing%20those%20behaviors%2Fhabits%20as%20%22positive%22%20or%20%22negative%22%20or%20%22neutral%22%20---%20or%20%22constructive%22%20vs%20%22destructive%22%20--%20or%20is%20that%20what%20you're%20trying%20to%20establish%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20since%20you%20clearly%20already%20have%20a%20spreadsheet%2C%20if%20you'd%20like%20more%20pointers%20on%20creating%20the%20Pivot%20Table%2C%20you'd%20help%20us%20help%20you%20by%20posting%20the%20spreadsheet%20itself%20rather%20than%20just%20images%20of%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

I have tracked my mood and habits over the past year:

Mood has been visualized as follows (1-5, 5 being best, tracked daily, averaged out over month):

mood.JPG

1.JPG

 

Habits have been tracked as follows, just not sure how I would visualize this in a chart?

fffff.JPG

 

Would there be any way to cross reference the mood vs habits in a chart as well?

Thanks for any help!

 

1 Reply

@May_Triggson 

 

The Excel Pivot Table is made for cross-tabulating things like that. You'd find it a lot easier, however, if you collected the two sets of data in a single table.

 

I'd personally recommend expanding the number of columns in that first table to show which behavior (some clearly are "habits" but others are less so; "behaviors" strikes me as the more inclusive term for them all...anyway, create a separate column for each, and maybe even consider categorizing those behaviors/habits as "positive" or "negative" or "neutral" --- or "constructive" vs "destructive" -- or is that what you're trying to establish?

 

Anyway, since you clearly already have a spreadsheet, if you'd like more pointers on creating the Pivot Table, you'd help us help you by posting the spreadsheet itself rather than just images of it.