my vba graph problem

[Hunden]

Hello, I got a little problem.

I got 1 workbook with currencies rates.
Looks like (USD=100):
EUR 120
GPR 45

I got 1 workbook with sales amount.
Looks like:
4USD
6USD
10EUR
2USD
10EUR
4GPR
2GPR

In this case I want to create a graph (Chart) in workbook3, that showing the distribution of sales on the various currencies. It is therefore necessary that the total sales amount of each currency is calculated. After that the amounts have to be determined in the same currency (USD)

[shg]

Please read the Forum Rules about cross-posting, and then post a link to other forums where you have posted the same question.

[Hunden]

Please read the Forum Rules about cross-posting, and then post a link to other forums where you have posted the same question.

It is same problem as on

http://www.vbaexpress.com/forum/show...189#post167189

[shg]

and also ...