Info Data on Pie Style

[#1]

I'm developing an application to represent a certain segmentation data. I tried to represent it with a pie, but on selecting prospective pie I cannot show some percent values and/or info on the single piece.

The only way to do this seems to use the front view pie , which shows all values (only those related to expression linked to the given segmentation) for each piece. However, I cannot show both these values (for example by segmentation in the legend) and relative values on the pie.

Is there a way to have this view?

Thanks,

Giselda

[johnw]

I'm not sure I understand the question, but is the attached what you're looking for?

[#3]

Hi John,

sorry for the late answer, but I was on vacation due to Christmas time!

Thanks for your help, but I don't think your example totally answered to my first question, that was about a prospective pie with quotes. The example is still concerning the front pie. So I meant to ask if I'm compelled to use only this kind of pie to show values on it.

However your example is very interesting for what concerns the problem of segmentation legend and percentage. Only a question: do you use two different tables to do this or place and sales are columns of the same table?

Thanks again,

Giselda

P.S: Happy New 2010!

[johnw]

dp2000 wrote:do you use two different tables to do this or place and sales are columns of the same table?

They are both columns of the same table. You can see the table structure by doing a ctrl-T, or File -> Table Viewer. I'm still not understanding the original question, but you've marked it as answered, so if you're happy, I'm happy.

[jolivares]

Hi, John

I was seeing this solution it's great for me But how may I put as legend both values in the side?

Thanks

[johnw]

Not sure I understand. In the example, you want it to say somewhere that the % is percent of sales and the number is the total sales? Or were you looking for some sort of mini-chart next to the "place" labels? Something like this?

place sales% sales
a 4% 180
b 6% 250
c 11% 500

Something else?

[jolivares]

Yes something like this, because if I mark "Show Numbers in Legend, just one value could be showed.

[johnw]

Hmmm, I haven't thought of any good way to do it. You could just put a simple straight table next to the pie chart. Or you could just not use a pie chart. I'd probably personally just display this data as a straight table with a bar chart column. See attached for both of those approaches.

[jolivares]

Good!

Check mine...

[johnw]

Jolivares wrote:Good! Check mine...

Very nice. I considered a background color expression, but didn't do it. Looks like I should have. 🙂