PDA

View Full Version : my vba graph problem



Hunden
11-20-2008, 07:51 AM
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)