Changing column name in Line chart

[Former Member]

Hello All,

We are BO 4.0 SP6.

We are creating WEBI reports which includes charts as well.

We have two columns " Current Period" and "Last Period" and using them in WEBI report and Line chart.

In the table I am displaying the column name " Current period " as "Oct-14" using some formula.

But I am not able to change the name in the chart.

Can we change the column name in the graph using some formulas? Please advice.

PFA the screenshot for your reference.

Regards

Prasad Ambati

[Former Member]

Hi,

Create 2 variables using Those formulas.

Now Add 2 Blank cells in Report & Align Them above Legend Text Properly ,

so that only Legend Text will Hidden below this variable Cell .

And Your formula will be next to Respective Symbol .

[Former Member]

Hi,

I am not able to get you.

I created blank cell and using the formula I got Oct-14 and dragged that inside the chart area.

After that what settings I need to change ?

Please advice

Regards

Prasad Ambati

[Former Member]

Hi,

Do not Drag it inside chart area .

Align Them above Legend Text ( Current Period ),

so that Actual Legend Text will be hidden .