Adding targets per sales rep

[dries_clairhout]

Good day,

I am trying to put monthly targets inside a graph.

This is the graph as is:

Now I want to have a line that shows the target per Salesrep in reference to the numbers.

This is an excel of the data I want to put in visualisation:

Any ideas would be welcome.

Kind Regards,

Dries

[Kushal_Chawda]

IS it bar or combo chart? How exactly target like should look like?

[dries_clairhout]

Hello,

right now it's a normal bar graph,

but it should be a combochart.

Where we see the sales numbers combared over the months.

and above it a line that represents the targets.

So when i select a certain representative I can see per month if the target is met.

Thanks in advance.