cancel
Showing results for 
Search instead for 
Did you mean: 

Change Legend dynamically iChart

Former Member
0 Kudos

Hi,

I have created a Bar chart. I have used SQL query template(Stored procedure) to fetch the data.

Now its returning "Value1" and "Value2" as values which I am plotting on graph.

So in legend description I am getting "Value1" and "Value2" itself. I want to change them to something meaningful.

Is there any property to change legend description in iChart?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Arpil,

There are a couple of ways I can see to do this, it looks like the only way to do this is to change the column name in the result set. The easiest way would be to do it in the SQL Query itself if possible:

SELECT Value1 AS SomeName

You could also change them in a BLS transaction, using the XML Function category's Column Alias action.

Kind Regards,

Diana Hoppe

Former Member
0 Kudos

Hi Diana,

I cannot change in stored procedure due to some constraint.

Is there any other way... Changing the Column name in in MII itself ?

Former Member
0 Kudos

Hi,

Heve you tried second option provided by Diana,

As Diana suggested you can try column aliasing action block in your BLS transaction.

Regards,

Manoj Bilthare