And again, the point of a graph is to provide as much data as possible in an easy and useful format.
The ideas for your first two graphs aren't bad, I just think for your study you can go with some simple tables and 2 simple bar graphs.
You really have 2 Groups with different activity levels (on your 1 to 7 scale).
Group 1 = Positive Emotions
Group 2 = Negative Emotions
*Group 3 = Neutral Emotions? (this is up to you, did you have any neutral ones?)
You could still make 4 = 0 and have negative values if you feel compelled. You could make the negative part of the graph Inactive and the positive part Active. And then graph it like that. I'd still stick with two graphs though for ease of understanding the information. But you could revise your second graph with similar axises and it might work.
I'd say do whatever you think works best
. And yeah.....graphs in excel is hard. Stick with Excel or a spreadsheet alternative.