Staked chart negative values should be on top

[umareddy0706]

Hello gurus,

I am getting negative values on below of base line.

but My requirement is to get the negative and positive values on top.

Please advise to get the desired chart.

Regards
Uma

[Satheesh]

hai,


Use the abs() function for negative values if it is specific and common.


you can get all in above...




Regards
Sateesh Chapparapu

[umareddy0706]

Hi Satheesh,

Thank you for your quick response.

But the actual value is going down.

For example.. for Product A.. I have actual score is 106%.  for the same product, competitor score difference is -6.

In above case, when I use ABS( ) function, I am getting like this.. 95% and 5%..

Please advise, if I can use any other chart also. that would be fine, to should this kind of positive and negative values.

Regards
Uma

[Satheesh]

Hi Uma,


If u use 100% stacked it will show 95% and 5%
But If u take Only Stacked Chart it will show 106 and 6


and mainly charts are Analysis purpose can u tell me what type of Analysis your Client want...???


Then only we can suggest you better chart.


Sateesh

[umareddy0706]

Hi sateesh,

There is a problem when I use ABS function, all negative values would be converted into positive values.

but my requirement is negative values pallette should show in red color. positive values palette should show in green .

Could you please guide me how to achieve this task?

Thanks in Advance.

Regards
Uma

[Satheesh]

HI Uma,




I thought Ur problem was rectified by using my solution if not inform me.




Sateesh