Bar Charts in Reporting Services

Hi,
can any one help me about bar charts.how to create bar charts in
reporting services.
Thanks in advance
Malli"How to add, move, or delete a chart (Report Designer)" in Reporting Services
Books Online would be a good place to start.
"Malli" wrote:
> Hi,
> can any one help me about bar charts.how to create bar charts in
> reporting services.
>
> Thanks in advance
> Malli

Bar Charts - possible to set max widths of columns ?

Hi,

Is it possible to fix the max width of the columns ? Sometime the report only generates 1 or 2 columns and it looks a bit odd as they're stretched to the width of the page.

Also, when we have a large number of culumns, say 20 odd, the legend text get's real squashed up and un readable, are there any tips/tricks so i can have more flexibility over what's displayed ?

thanks

Steve

i have the same issue. i would like to be able to set the width of the bars in the bar chart so that i dont end up with 2 fat bars or 20 razor thin bars. is there a way to do this?

bar charts

hi,

I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this.

thanks,
naveen

Go to properties on the chart. Then choose the Data tab. Choose the value you want to show the value for and then Edit, In the Point Labels tab I think you will find what you are looking for.

Bar charts

I have created a bar graph but cannot find a way to change the bar's color for different series.

I have a graph which has sales men and their sales between dates

Thanks for your help

Hi there,

There are lots of postings for this. Can you try this one?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=222204&SiteID=1

cheers,

Andrew

|||Have you set up a series group?|||

No I hadn't

Thanks for your help

|||

The only problem Im getting with setting it up as a series group is the chart lines are now the size of a match.

Is it possible to fatten them up?

sql

BAR Chart Customization

I have a requirement in bar charts using SSRS to show an additional image along with the Data label.

Assuming A, B, C are the products getting displayed and its performance rating is 25, 35, 30 respectively. I should get the Product Related Image next to the datalabel. Please let me know if there are any possibilities available to generate such report using SSRS...Thanks

HI,Coras

Here's a neat trick a co-worker and I have found for creating aninline bar chart(an inline data visualization in a table or other data region).

1. Add an embedded image to your report that will serve as the "bar" (a simple horizontal gradient usually looks nice)

2. Add a column to your table, and place an Image report item in the detail row cell.

3. Select the embedded image from step 1 as the source for the Image report item.

4. Set the padding on the Image report item to adjust the size and position of the bar within the cell

5.[Here's the kicker] Create an expression for the right (or left) padding that divides a field value by some maximum value, clamps it to a given range if necessary using Math.Min/Max, and then multiplies by the total size of the bar.

Example:image1.Padding.Right=((1.0-(Math.Min(Math.Max(Fields!TotalSales.Value,0),100000)/100000))*72) & "pt"

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi Rex,

Thanks a lot for your reply...Just for us to synchronize our thought, I am adding few more points here

Since I am not able to add my Excel image in the forums as it throws error, I am trying to show you the graphical representation of the image as below

|__________________
|__________________|
|
|_______________
|_______________|
|
|
|
|__________________
|__________________|
|
|_______________
|_______________|
|
|_____________________

If you see above in the chart, the smileys occupy at different places based on the value of the bar. This is the way I would like to have my chart...Please let me know if you need any further information for developing such reports..Your advice is much appreciated. Thanks

Regards,
Coras

P.S: Request you to arrange the chart available as lines, if this gets scattered after the post..