What's the best way to visualize this data?

Question

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

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

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

Thanks for any help!

Answer 1

@May Triggson

You could try to select the data of Habits, click Charts in the icon in the lower right corner, click More.

Choose the chart you like in All Charts.

You could filter the habit you would like to check.

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.

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.