Two-way line graphs

[Lena Gan]

I hope someone can help me as I have spent countless hours trying to recreate the graph output in journal article. Both DV: FS_Scale and IV:runoutworry are categorical predictors (Likert Scale from 1-7) and I want to show the trend (+/-) . For e.g. how many people on the 7 pt runoutworry(x-axis) is also showing up also as 7 pt on y-axis FS_Scale? The output I want to mimic is able to show 1 -7 for both x-axis and y-axis but when I coded it, it came out showing frequencies on y-axis instead. I think I am doing something wrong or is it impossible? Thank you so much.
Here is my code
drop if runoutworry==. drop if FS_Scale==. collapse (count) runoutworry, by(FS_Scale) browse twoway (line runoutworry FS_Scale, sort lcolor(black) lwidth(medium) lpattern(longdash)) (scatter runoutworry FS_Scale, msize(medium) msymbol(circle) mlabel(runoutworry) mlabsize(medium)), /// ytitle(count of run out worry) ylabel(0(200)1000, angle(horizontal)) xlabel(1(1)7) legend(off) plotregion(margin(large)) xtitle(FS Scale)

[Fei Wang]

Lena, if you are attempting to recreate the article graphs, I guess they plot how the average Financial Satisfaction changes with Financial Capability / Subjective Financial Knowledge. Therefore, you may need to collapse the data to generate mean Financial satisfaction by the x-axis variables. Something like:

collapse (mean) FS_scale, by(FinCap_scale)
twoway connected FS_scale FinCap_scale, mlabel(FS_scale)    //upper graph

[Lena Gan]

Thank you so much Dr Fei Wang. It really worked! I spent days on this. I really appreciate it. Lena