How to chart $ by postcode - data in 2 tables

[Wunjowun]

Hi Chandooers,

I have 2 tables - customers and orders as per attached - CustomerID in common.

I would like to chart sum of UnitPrice by postcode.

I'm hoping someone point me in the right direction to get started.

Best wishes,

Wunjowun

 

[Hui]

Do you want a simple Column / Line chart or a geographical chart ?

 

[Wunjowun]

Hi Hui,

Thanks for reply.

Just a simple line/column chart will be fine.

Best wishes,
Wunjowun

 

[Hui]

First add a Post code Column to the Orders
I2: Post code
I3: =INDEX(Customers!$M$3:$M$53,MATCH(C3,Table3[CustomerID],0))
Copy I3 down

Goto Customers Tab
Select Post Code column

Data Advanced (Filter)
Tick Copy to another location
List range: $M$3:$M$53
Criteria range: Empty
Copy to: Q3
Tick: Unique records only

Copy the list of Post codes to Sheet 3
Note the top post code is probably repeated, deleted it

On sheet 3 assuming the list starts in B3:
In C3: =SUMIFS(Table2[UnitPrice],Table2[Post code],B3)
Copy down

Select data and Insert, Chart


If that makes no sense see attached file:

 

[Wunjowun]

Hi Hui,
A big thank you for your good advice (and apologies for the lateness of it).

Was able to use it to complete my task and my index/match and sumifs skills much better for it too!

Thanks again,

Wunjowun