Pie chart Negation

[#1]

Hi,

I have a scenario where in I have to plot a pie chart with 2 different values. One being my original expression (say for example it is 20%) and rest other categories are not having any values (0). Hence I have to show the pie chart including this 80% as one angle for all the zero values and 20% as other angle in the same pie. Is there a way I could negate my original expression and achieve the second expression? I could get this easily with a bar/mekko chart but not with the pie !

Thanks !

Arun

[MarcoWedel]

please post a sample application

thanks

regards

Marco

[#3]

HI Macro,

I have attached a sample file for you. Please let me know if this helps.

Thanks!

Arun

[#4]

A point to add to the above note, the same expressions work good for other charts like a bar or a Mekko chart. It does not work with the Pie.

[Anil_Babu_Samineni]

Thanks for sharing App, Now coming to your query. Is that possible to show which you expect from Pie chart. Please make sketch on paper and then share with us. So, Might very helpful to explain you

[Siva_Sankar]

Hi Arunkumar,

Please find the attached app. For the purpose you are looking for , Bar chart is appropirate.

However, i tried concatenating the field and created a pie. please take a look

Siva !

[Anonymous]

Hi Arun,

As you can show individual graph for each designation in single object using trills option.

please find the below attachment, iam nt sure it meets ur requirement.

Regards,

Murali Mohan .T

[sdmech81]

HI Arun this is what u want??

Or further u want that 35 and 65 to b distributed based on designation?

If above is wt u want I ll share with u..