# Graph Panel - how to group the data into separate lines

**URL:** <https://community.grafana.com/t/graph-panel-how-to-group-the-data-into-separate-lines/12615>\
**Category:** MySQL\
**Tags:** mysql\
**Created:** [December 5, 2018, 8:59am UTC](https://community.grafana.com/t/graph-panel-how-to-group-the-data-into-separate-lines/12615 "2018-12-05T08:59:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ayag](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@ayag](https://community.grafana.com/u/ayag)\
**Post date:** [December 5, 2018, 8:59am UTC](https://community.grafana.com/t/graph-panel-how-to-group-the-data-into-separate-lines/12615/1 "2018-12-05T08:59:23Z")

</div>

Hello !  
My data source is MySql.

My table look something like that  
 ![image](https://us1.discourse-cdn.com/grafana/original/2X/8/8641a10b9e53b5b11199d41dfa0d391ee83e0ff1.png)

I want each person will have a separate line in the graph

![image](https://us1.discourse-cdn.com/grafana/original/2X/d/d797ba4e2a719eeb96a068575ebebe931e54fa6c.png)

I tried to use series, but I failed… (I’m not sure what is the use of it…)

the only way I succeed was to change the table format to  
 ![image](https://us1.discourse-cdn.com/grafana/original/2X/e/e653951cbf5753b1d9011138a0573e3dc4d788bd.png)

but it is not a good solution cause the number of person is changing all the time…

Can someone help me?

Thank you!