Need help with excel graph

[Rizzy73]

For example how would you represent the x axis of a graph in the following scenario:

Product Currency PaidAmount
Prod1 AED 15.00
Prod2 AED 16.00
Prod2 GBP 17.00
Prod2 HKG 18.00
Prod3 GBP 20.00
Prod3 EURO 25.00

If your legend has Prod1, Prod2 and Prod 3, for example Prod2 has three occurences of different payments (14.00, 15.00 and 17.00) and paid in different currency (i.e. GBP, EURO and AED)

How can I show in excel the different currency of payment on the a axis with the specified total?

[rcm]

if you organize it as so, then choose a staked bar type of graph..

AED GBP HKG EURO
P1 15
P2 16 17 18
P3 17 20 25

[rcm]

if you organize it as so, then choose a staked bar type of graph..

AED GBP HKG EURO
P1 15
P2 16 17 18
P3 17 20 25