Charts with DropDown Box

[rejir007]

I have data of Countrywide imports, exprts and production for 8 countries and for 3 products. I want to make a graph using dropdown box as the country or products so that i change the variables the graph also change. Please help me how it can be doen Form Tool bar

 

[gardnertoo]

Are you wanting:

A. ONE imported/exported product to/from ONE country
B. ONE imported/exported product to/from ALL countries
C. ALL imported/exported products to/from ONE country
D. SELECTED (one or more) imported/exported product to/from SELECTED (one or more) countries?

 

[rejir007]

Dear Expert,
Thanks for the reply. I want to show the Countries in teh X axis and the quantities in the Yaxis. But I want to create a drop down box for the products in the graph so that when I change the products the graph will also change. Pl help me

 

[PaddyD]

Have you considered a pivot chart?

 

[jolivanes]

Or check out Tushar Mehta's site.

 

[rejir007]

Thanks for the reply. I wanted to create the graphs with Form toolbox, like Spinner or dropdown box, so I can change the graphs by changing the name of Products.

I want to show the Countries in teh X axis and the quantities in the Yaxis. But I want to create a drop down box for the products in the graph so that when I change the products the graph will also change. Pl help me

Pl. Help me. TusharMehta site couldn't help me. please