Need to display data in x,y axis accordingly selections...!!!

[buzzy996]

hi guys,

i am having in a table 4 columns

col1        col2    col3     col4

month1    A1      234     A

month2    A2      237     A

month3    A3      2389   A

month4    A4      232     A

month1    b1      234     B

month2    b2      237     B

month3    b3      2389   B

month4    b4      232     B

I need to display in chart, x axis as month(Col1),col2 and col3 are selection parameters those 2 columns information need to display in chart..accordingly selection col4,if i select col4 as A then need to display only A1,A2,A3,A4....if i choose as COL4 as B..then need to display only B1,B2,B3,B4,.......If i choose col4 as A&B then need to display all records of COL2........how to to do?

any help!!!

[rohit214]

hi

please find the Attachment

thanks

rohit

[buzzy996]

hi rohit,

thanks for ur quick replay..

but my data some thing like this..

col1        col2    col3     col4

month1    A1      234     A

month2    A1      334     A

month3    A1      434     A

month2    A2      237     A

month3    A3      2389   A

month3    A5      2489   A

month3    A6      2589  A

month4    A4      232     A

month1    b1      234     B

month2    b2      237     B

month3    b3      2389   B

month4    b4      272     B

month4    b5      282     B

month4    b6      292     B

how to do tis is the case?pls let me know anyone..

[rohit214]

hi

please find the attachment,if i am getting you  wrong ,then please explain me

please find the attachment

and let me know if   it is satisfy your criteria.

thanks

rohit

[buzzy996]

actuly i need to display the above info at cahrt level,when i amtrying to to choose COL4 A and B

then IN X-AXIS is changing and getting COL4 as X-axis.

Actuly need to diplay X-axis as a month every time,and according COL4 selection all COL2 info as a line.

any help..

[rohit214 · Accepted solution]

hi

please find the attachment

thanks

rohit