Pie chart should look like th eattached image

[avik1986]

I am able to show the value but the % are coming in another column . Please suggest how to show that.

[BigChris]

Might just be me, but I can't see an attachment

[Lynn]

Me neither.

[MFGF]

I just took a look at the original post, and there are no attachments and no hidden links, so you're not missing anything Chris or Lynn.

All I can suggest is the old Cognos message you'd get from Quiz if you tried to run a Quiz report containing graphics terminal plot commands on a non-graphics terminal...

"Imagine a circle..."

MF.

[Lynn]

[MFGF]

I feel slightly giddy! :)

I'm also having trouble reading the % values on that one, Lynn! :D

MF.

[BigChris]

I suddenly have a strong desire to cluck like a chicken...and I seem to have lost the last 10 minutes, ever since I opened Lynn's post.

[avik1986]

Sorry of not attaching the image. I have attached now

[BigChris]

It seems rather appropriate that my 1000th post is about pie charts  ;). I'm an advocate of the Stephen Few approach to pie charts, in other words I almost exclusively avoid them. If you haven't read his article, it explains much more eloquently than I can the reasons why other formats work better:
https://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf

I've taken the figures from your attachment and produced two very quick formats, both of which I'd argue are easier to read than your 3D pie chart...take a look and see what you think.

[hespora]

I've taken the figures from your attachment and produced two very quick formats, both of which I'd argue are easier to read than your 3D pie chart...take a look and see what you think.

Booo! Booo! Booo! Can't even do simple math! Your percentages don't add up to 100! Booo!


(scnr.... :D)

[BigChris]

Your percentages don't add up to 100! Booo!

LOL - that's the risk of using Excel and letting it round to the nearest whole % figure

[hespora]

Aaaaaaaanyways... to answer the OP's question:

Don't try to put two measures into the crosstab. Just, in the piechart's properties, find "chart labels", and set it up like shown in the screenshot attached.

Disclaimer: By answering this question, hespora takes no responsibility for poor business decisions that are rooted in faulty understanding of data due to the usage of piecharts. I do not condone the usage of piecharts, and answering this question can not be construed as such. Use at your own risk, and seriously, read that essay that BigChris linked.

[hespora]

LOL - that's the risk of using Excel and letting it round to the nearest whole % figure

Yea, I figured that. But I guess we all will have had some business user yell at us for that exact reason... ;)