Comparison price (national and world price) in one graph

Hey community.
I would like to show in one graph the competitive average price of category of item from France but also the the competitive average price of category of item from World.
I put the worksheet "Template". I've create two pivot tables on the sheet "ND-France",

Capture.PNG


Thank your for your help.

Hi,

See attached.

I added three helper columns to your data
In column L I first had to use =TRIM() since some categories had leading spaces in some countries
I also had to change "Recheargeable Battery" to "Rechargeable Batter" and "Wireless M" to Wireless Mic" in some cases