Legend Properties??

[#1]

How to change the properties of legend on a bar chart/scatter chart?

I am using a bar chart and I am representing two bars(each corresponding to a year : 2011, 2012). And under each bar I have two sections (one color for each). In the legend I get 4 options (2 green and 2 gray), but I just want 2 optionsin the legend (1 green and 1 gray).

How do I fix that?

Please find the attachment for the qvw file

[#2]

There is one thing I still did not get .

Number format on a text box. I tried using this function, but it is not getting reflected.

Can you help me on this?

I will delete this once I get ur reply.

this is to format the number and have thousand separator

num#((sales),'#.#','.',',')

[MayilVahanan · Accepted solution]

Hi,

Try this,

     =Num(Sales,'#,##0')

     For example

      =Num(2468264,'#,##0') gives 2,468,264

Hope it helps

[#4]

Thanks it worked,

What is the difference between num and num#??

[MayilVahanan]

Hi,

From tutorial :

num#(expression [ , format-code[ , decimal-sep [ , thousands-sep] ] ])

The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters.

- its used for text

-in your files data is in string format rather than number format like sales => '12345'

Ex:num#(sales,'#,##0') gives 12,345

For same example mentioned  above, wen u give as

=

Num#(2468264,'#,##0')  gives 2468264 only

num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters.

-its used for number

-in your files data is in number format like sales => 12345

Ex:num(sales,'#,##0') gives 12,345

For more details

Please see the referenue manual

[#6]

     =Num(Sales,'#,##0')

     For example

      =Num(2468264,'#,##0') gives 2,468,264

This works. Now if we have to give space instead of ','...how do we include space inside that expression???

[MayilVahanan]

Hi,

Try like this,

     =Num(Sales,'# ##0','.',' ')

For example

     =Num(2334242000,'# ##0','.',' ')

GIVES 2 334 242 000

Hope it helps

[#8]

Yes that worked!

Sorry again to post it here, I willdelete it as soon asyou answer this

Mayil,

Do you know how to fix the width of a each cell?

I do not want to drag and fix the size. I have to have every column of the same width. Do you know how to do that?

[MayilVahanan]

Hi,

     In Chart -> right click -> fit columns to data or Equal column width

     Hope it helps..

[#10]

Hi,

thanks but this does not help because I do not want it that way, I want to manually fix the size.

Like under caption we have option to enter the number of pixels for the horizontal or vertical length of the chart, I want to know if there is a place where I can give the width of each cell in the chart

[#11]

I could not find either.

anyway thanks for the help