Chart label modification

[#1]

hi,

     I need to fit the labels below bar chart shown in figure, for example on 1st bar (Renewal Premium Cheque Pick up-cc ) i need to adjust it as

Renewal Premium

Cheque Pick up-cc one below another .??

[whiteline]

Hi.

Select the chart then press and hold Ctrl+Shift.

Now the red boarders are shown and you can move the objects within the chart.

[sujeetsingh]

Whiteline has told you the option just play with it

[sushil353]

Hi,

you can also change the orientation of the chart.. for the label's having lengthy names .. it is preferable to make the chart in horizontal way..

you can change the chart orientation from style tab of chart properties.

HTH

Sushil

[#5]

hi whiteline i tried press and hold Ctrl+Shift. option but unable to get

Renewal Premium

Cheque Pick up-cc in

[perumal_41]

can post sample application

[rwunderlich]

You want your labels to split multiline. You can only display multiline labels when you select the diagonal format "/" on the Axes property pane. And you must split them into multi line yourself. It's easiest to do this in the script.

See this post for how to split them in the script.

Displaying long labels on chart X-axis

-Rob

[whiteline]

Sorry, not noticed that it's  a chart label not the floating text.

Look at the solution Rob's posted below.

[Anonymous]

Hi,

You can't split labels in multiple line horizontally, however if you have fix category or want to show top 5 label you can use FirstSortedValue() function to calculate label and use "Text in Chart" option to show on chart. Please Note, you have to align these labels properly on the chart and unchecked show legend option to make it real bar chart.

Below chart shows top 3 constraint plan in horizontal multiline.

Thanks

[rwunderlich]

Can you attach a sample QVW that demonstrates this?

-Rob