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

Example.xlsx

[Fotis1991]

No need to start many threads for the same question.

So...



Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...otgraphic.html

Thread Closed.

[kartoshka]

Hello, Im sorry but it was not my intention to duplicate, my browser stopped and i thought that it didn't open the thread so i went back and tried again, then i realized that was duplicated and i was trying to erase it.

[Fotis1991]

OK. No need to worry for this. Sometimes happens.. Soon a Mod will close this thread and you can continue to your original thread.

Good luck with that.

[arlu1201]

Thanks Fotis.

Thread closed.