Excel graph or SSRS

[J4L]

Hi All,

I am in need of some suggestions - i have about 130 data descriptions with values which i want to plot in a graph (side bar graph view).

Now obviously the graph will look all messy and crunched up due to the amount of information being displayed.

Is there any way i can do grouping, i.e. group the descriptions and plot the values against the group? hope that makes sense or see where i'm coming from!

I intend to do it either in excel 2007 or SSRS - which ever is more suited best.

Thanks

 

[sijpie]

Yes, one way would to be to group the labels in the correct way, then in an extra column have one group description per group and empty lables for the rest. Now use that for your chart range

 

[J4L]

Yes, one way would to be to group the labels in the correct way, then in an extra column have one group description per group and empty lables for the rest. Now use that for your chart range

Thanks for your reply - i'm not getting it right, would you be able to take a look at the sample file for me?

 

[sijpie]

Sure, you can post it somewhere and send me the link in a private message.

 

[J4L]

Sure, you can post it somewhere and send me the link in a private message.

I have PM'd you a link which will take you to the xls file where i've uploaded it - appreciate for taking a look.