Please help with presenting data in different collumns in a graphic/pivotgraphic

[kartoshka]

Good evening everybody,

I'm writing because i have a question regarding how to present some data in a graphic or pivot table graphic.

I have 2 columns with a list of competitors (competitor 1 & competitor 2) involved in a negotiation + the price/value of the negotiation.
Each line represents a negotiation with a value in numbers & the names of the 2 main competitors involved.

I have around 150 lines in the original file and would like to show in a graphic what are the competitors that we regularly find in the negotiations and what is the value of the negotiations they are involved.

The problem is that there is no main competitor so i can find the same name in any of the 2 columns and i cannot make separate graphs for each column because if i do so i duplicate the value.

Is there any way that aggregate this info into a single graphic/pivot graphic? Im using excel 2013

Attached my file with the example

Is this possible? Can anyone help me/have any idea?

Thank you

[rajeshturaha]

Hi kartoshka,

Welcome to the forum.
I have attached a file. See if it can help.

[kartoshka]

Hello Rajesh,

Thanks a lot for your help, this is exactly what i was looking for.

Very happy that i joined this forum and amazed on the power of a community and the will of helping others.

Regards