Hey Stata community,

I tried to plot something using a panel data set and the "line" command (sales over time from 20 different companies).

Unfortunately, Stata shows me for each company separate lines. I just want to have 1 line over time (the mean of sales from all companies).

To demonstrate, I added a graph.

How can I see the mean line instead of 20 lines in the plot? Is there a mean-command that works?

Many thanks and best regards!
Array