We are comparing two customers based on sales strength. Below is the table which is fixed to compare the customers.
Customer1
Customer2
A
D
B
F
C
E
H
G
I want to create a customer wise sales bar chart, so that if I select any customer from Customer List Box, the bar chart will show corresponding Customer1 vs Customer2 sales.
i.e. If i select G, the bar chart will reflect Sales for H & G.
Note : We have more than 200 customers, so the solution should be dynamic....
