I have been trying this for many days...but i have not got any result. I have even googled extensively. Please help me out in this. This is my last stop.
I have to plot graphs based on data in a access table. the data is some thing like this
Area Commodity Month Target Actual
Chicago Tea Jan 100 95
Chicago Coffee Jan 100 99
...
...
There are about 5 areas...5 different commodities and the data for months jan to dec.
I need to plot Target and actuals for each combination of Area-Commodity-Month
how to do this...in the wizard...it is not allowing me to give more than 3 variables.
any way to do it using vba.......???
Please Help
Thanks
I have to plot graphs based on data in a access table. the data is some thing like this
Area Commodity Month Target Actual
Chicago Tea Jan 100 95
Chicago Coffee Jan 100 99
...
...
There are about 5 areas...5 different commodities and the data for months jan to dec.
I need to plot Target and actuals for each combination of Area-Commodity-Month
how to do this...in the wizard...it is not allowing me to give more than 3 variables.
any way to do it using vba.......???
Please Help
Thanks