Charts in Crystal Report

[bond24]

I need some help to display the following data in Bar graph
A B C D
X 10 15 50 75
Y 12 25 35 45

can some one help how to dispay the above data in bar graphs?

i tried using Advanced option in chart Expert, but i am not to figure it out how to display it.

Thanks n advance

 

[Madawc]

Depending on your Crystal version, you should be able to do a bar graph for two separate variables.

Please say what you have tried and what is giving trouble.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[bond24]

Thanks for the reply!
let me say what is was doing waas in char expert, i was
using Advanced chart layout, in "show values listbox" i m giving x,y.Problem is , i m not able to give all A,B,C,D in "on change list option", i m able to give only two A,B.So, this is the way i want to see the graph.
For A - I want to see X,Y
For B - I want to see X,Y
For C - I want to see X,Y
For D - I want to see X,Y
i hope i made it clear!

 

[chelseatech]

Sounds like a Stacked Bar chart will do what you want.

Use an Advanced chart, selec the field that contains A,B,C as the Change Of, and the field that contains X and Y as the two summarised values

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[bond24]

i tried that one, i seleced A,B as the change of, but when i selected C its overriding B and showing A,C in change of list box.i m not able to select more than two items.
Do you have any idea why its doing like this!

Thanks for your reply

 

[lbass]

Are A, B, C, and D separate fields? Are X and Y instances of the same field? It looks like you are just using letters to simplify, but it might be clearer if you referenced actual field names and then showed the instances of those fields.

-LB

 

[bond24]

Thanks for the reply. sorry to confuse guys!
i m uploading the excel file, i just want to show the graph in
crystal report, the way the excel file shows.

 

[bond24]

i m not able to upload my excel file, is there any procedure for this!upload picture is disabled it seems.

 

[bond24]

i m not able to upload my excel file , is there any procedure for this!

 

[bond24]

i m not able to upload my excel file , so below is the data.So i want to show Clients, Rec , Verbal , Missing,FID's by county.Hope it will clarify abit.

County Clients Rec Verbal Missing Fids
HCAD 69,285 58,801 2,942 7,542 61,743
non HCAD 41,192 35,722 977 4,493 35,722