requirement to show target value behind actual value in chart

[nikhil_joy2]

Hi Experts,

I have a requirement in Xcelsius 2008 to show data in chart where in each bar, target values coming behind the actual values. that is the target will be in grey colour and wide bar. Acrual values will be in different colours and narrow compared to the width of target bar.

I want to show the measure of three group of unit in a single value in X axis say month. ie three grey bars with different height and on each bar actual values will be in three different colours.

I am planning to use combinational chart componet where we could use target as bar and actual values as lines.

Is there any alternative way to achieve this functionality. Any help would be greatly appreciated.

Let me know if you need more info.

Thanks in advance,

Nikhil Joy

[Former Member]

HI

Try to use two charts and put those charts side by side (in the sense place one chart over another just move the second one step side left).

then change marker size in on chart and use different marker size in second chart as per your requirement .

regards

Venkatarao.S

[nikhil_joy2]

Hi Venkat,

I will try it out. Thank you for your valuable input.

Regards,

Nikhil Joy