struggling in ichart - bar type

[former_member200568]

Dear Experts,

We are in process of generating the alerts in MII for Yield at monthly level.

Below is my table for which i want to generate the Ichart in MII transaction & sent it in email action block.

Plant	Month	yield drop 10%	yield drop 20%	yield drop 30%
XYZ	Jan-16	2	3	4
XYZ	Feb-16	1	4	5
XYZ	Mar-16	2	6	8
XYZ	Apr-16	0	1	4
XYZ	May-16	1	3	5

Requirement:

on x axis --> month

on y axis --> 10% yield drop , 20% yield drop, 30% yield drop

Chart should show month wise data for 10%,20%,30% yield drop.

When i am creating the Ichart --> bar type, random colors are displayed as the value of Y axis properties.

In short i want my bar color in standard format:

such as, 

For yield drop 10% --> Red

For yield drop 20% --> Green

For yield drop 30% --> Yellow

for every month.

I want chart in attached format. ( I want to attach the chart in Sent mail action block so i can only use ichart option only , I was able to get the required result by selecting i5chart in dashboard ). 

Please guide me how i can get static colors for Y axis.

I have searched the SDN for this but not found the perfect answer that can resolve my issue.

Regards,

Deep Dave

[Former Member · Accepted solution]

Hi Deep,

In the DataSeries you can configure the color of each data

In your ex, you have 3 data series and you can select the required configuration [color and type] in the above place and see how it renders. Pls post a screenshot of iChart result.

If even after changing the colors in the above place doesnt help, then change the Chart Type to Custom and in Dataseries, for each series select type as Bar.

Regards,

Sriram

[former_member200568 · Accepted solution]

Dear Sriram,

Thanks for the prompt response.

I achieved the objective by custom chart & suggested data series.

However i am not able to generate data series values on top of every BAR which is generating.

tried with show value option in chart area.

I want to show value above or below each bar.

Please refer attached image for requirement.

Regards,

Deep Dave

[Former Member · Accepted solution]

Hi Deep,

Show value by marker property will show values of each bar in the below manner.
it does not appear above/below. Which version of MII are you using?

Regards,

Shruthi

[former_member200568 · Accepted solution]

Hi shruti,

I am using MII work bench15.0.4.5.

I have selected chart type as custom type.

refer below screen shot of chart area settings for graph & let me know where i am missing out.

regards,

Deep Dave

[former_member200568 · Accepted solution]

Dear all,

Thanks for all your help.

I have achieved my requirement as suggested by both of you.

Thanks & regards,

Deep Dave