6 Replies Latest reply: May 2, 2016 8:46 AM by Bernd Jägle

# Pie chart - have the absolute as well as the relative values?

Hi,

I have something very simple - just for a presentation: A piechart with four different types of costs.

- There is a checkbox "relative" to select to either have the absolute or the relative values in the charting_area - I have chosen the
relative values, I have the absolute values in a table above the chart.

- On the "presentation" tab, there is a checkbox to have the figures in the caption as well.

<=> These are also relative, I assume that's because I have chosen relative values on the other tab.

Is there a way to have the absolute values in the caption and the relative values in the charting_area (other than writing the values in a nr. of free_text_boxes)? That way, I could actually drop the table above and make the chart a bit bigger.

Thanks a lot!

Best regards,

DataNibbler

• ###### Re: Pie chart - have the absolute as well as the relative values?

you can duplicate your pie chart expression and make the first one "Relative" and the other "Absolute"

• ###### Re: Pie chart - have the absolute as well as the relative values?

you can also add type of cost as a third expression.

• ###### Re: Pie chart - have the absolute as well as the relative values?

Hi Jonathan,

duplicating the formula seems like a good idea.

Only then I have two values around the chart of course.

I would like only the relative values around the chart and the absolute values in the legend.

P.S.: Ah - I have it. I just unticked the "figures in chart" checkbox in the first formula, that way I have only those from the second formula - the relative ones - around the chart. Nevertheless, the legend uses the ones from the first formula - the absolute ones.

Thank you!

Best regards,

DataNibbler

• ###### Re: Pie chart - have the absolute as well as the relative values?

unfortunately, I haven't encountered a solution to that requirement. the numbers in pie chart legend take on

Relative/absolute form from expression property. I think this is by design.

• ###### Re: Pie chart - have the absolute as well as the relative values?

you can use a listbox with expression as Legend to your chart, It can sit on top(Layout) of chart or right next to it.

• ###### Re: Pie chart - have the absolute as well as the relative values?

Nice way to solve it. Thanks.