question

MayTriggson-2242 avatar image
0 Votes"
MayTriggson-2242 asked ·

What's the best way to visualize this data?

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):

55121-mood.jpg

55095-1.jpg

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

55114-fffff.jpg


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


Thanks for any help!


office-excel-itprooffice-powerpoint-itpromicrosoft-graph-workbooks
mood.jpg (67.8 KiB)
1.jpg (65.7 KiB)
fffff.jpg (28.6 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

erinding-msft avatar image
1 Vote"
erinding-msft answered ·

@MayTriggson-2242

You could try to select the data of Habits, click Charts in the icon in the lower right corner, click More.
55351-1.png
Choose the chart you like in All Charts.
55371-2.png
You could filter the habit you would like to check.
55343-3.png

If you want to cross reference the mood vs habits in a chart, you could try to put the two data in the same worksheet and correspond the date like below.
55344-4.png
Then you could follow the above steps to choose a chart for them.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.png (40.2 KiB)
2.png (46.0 KiB)
3.png (39.6 KiB)
4.png (23.3 KiB)
· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MayTriggson-2242

Have you checked my answer?
If you have any updates or questions, please let me know.

0 Votes 0 ·