How to increase the legend size of the charts

Question

Post reply

How to increase the legend size of the charts

peace.cog

SSC-Addicted

Points: 493
More actions
September 22, 2010 at 8:45 am

#240679

Hi,
I am new to ssrs. Could anyone help me in finding out option to increase the legend size of the charts.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 1

Hi

If u want change the appearance of legend

go>>>>on chart right click>>> properties>>>click option Legend>>>>There u can do any thing

if u want change legend data names or any data related ?

go>>>>on chart right click>>> properties>>>data>>>series labels>>>edit>>>>series label style>>>then u can do what ever u want .

If u have any doubts plz feel free and ask me

Thanks

Regards

sank

peace.cog SSC-Addicted Points: 493 More actions · Answer 2

Hi Sank,

Thanks for your response.

My exact problem is if my series label is too lengthy its not visible properly in the output because of legend table width. And I couldn't find the option for increasing the width for that.

-Shanthi

VinceV Right there with Babe Points: 791 More actions · Answer 3

Perhaps this might work for you:

Right click on the legend and select legend properties.

In the dialog that pops up, select "row" for layout and choose bottom for legend position. This way the legend can expand to the full width of the chart.

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 4

Hi

For legend we can't write long names we have to reduce word length.Other wise it's not possible to display the words.

Sank

VinceV Right there with Babe Points: 791 More actions · Answer 5

It is definitely possible to display long legend text in SSRS 2008. (I can't speak for other versions though). Click and select the legend. Press 'F4' to display the Properties pane in BIDS. Change the TextWrapThreshold to some larger value. You may want to make sure the layout property is wide table or auto table as well depending on what your needs are. Doesn't hurt to experiment with the other properties as well. Bottom line is that you can make the legend as wide as the chart itself and the text can be displayed in full.

peace.cog SSC-Addicted Points: 493 More actions · Answer 6

I think it is possible in 2008. Unfortunately in 2005 I couldn't find any such properties. I even tried changing the position to the bottom and made it as row type but of no use. 🙁

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 7

yes in 2005 it's not possible,i don't now about 2008

sank

samanth.xyz Valued Member Points: 50 More actions · Answer 8

Here is one of the alternatives to add the legends in a seperate table outside the chart.

http://msdn.microsoft.com/en-us/library/aa964128(v=sql.90).aspx

Julie.Wise SSC Enthusiast Points: 111 More actions · Answer 9

This must be a newbie issue. I have the same situation, except my legend is longer than my chart. I've attempted the suggestions above my expanding the textwrapthreshold and tested both Wide and Auto options. I'm only missing 1 character at this point. A closing parens. No problems when my legend contains only 2 items but 3..... to 8. I get all names except the last ')'. More ideas?

Julie.Wise SSC Enthusiast Points: 111 More actions · Answer 10

OK This newbie returns and quite embarresed to communicate that the issue I had was between the keyboard and the chair. The reason the suggestions did not appear to work is all me! Blast - Did I mention I am a newbee? Thank you for your time. - I won't be making that error again anytime soon. - So sorry if anyone spent time on this.

alex_2356 SSC Veteran Points: 298 More actions · Answer 11

Sounds like a quite baisc question, don't know if you had fixed it or not. I am also new to the chart control, the chart legend is quite complicated to me.