HOW TO TOGGLE CHARTS ?

[#1]

I have 4 Chart Tables with varios data. I need to make all this into 1, by toggling them. So lets say i have 4 Charts tables named

1)SONY

2)DELL

3)APPLE

4)PANASONIC

I have to toggle all 4 of them with maybe a button, so there would be a button saying, " CLICK FOR DELL" or "CLICK FOR APPLE" or "CLICK FOR PANASONIC. ( IF MY INTIAL SELECT WAS AT SONY).

How do you go about doing this? I added a recent post on how to toggle input boxes, i used the same apporach, but it did not work.

Please do try this out!

Thanks! =D

[#2]

Thanks Deepak!

The statement you gave was,

Crosstable

(Price, Amount, 3)

So, crosstable applies for only 3 variables? or can we add more if we want to ?

[deepakk]

hi,

It Means after 3rd field convert all other fields to row format.

Crosstable(Data,Value , 2)

Load a,b,c,d from table

This will covert c and d field into row.

[#4]

Hi Deepak.

Okay, so if,

(Data,Value,3)

Load A,B,C,D,E,F,G from table.

Convert D,E,F,G field into row.

And if,

(Data,Value, 5)

Load A,B,C,D,E,F,G

Convert F and G field into row. Is that right?

So the trick about using crosstable is the Number variable at the back, because it comments the amount of lines it is put as.

And Data would be the heading of the List Box created. And Value would be A,B,C,D,E,F,G.

Thats pretty cool! Thanks Deepak! =D