We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc - How to create a percent stacked chart with percentage relative to a value

asked 2020-06-15 05:49:43 +0200

estevaog3 gravatar image

I have the following spread sheet. image description

The chart is showing the relative percentage of each data value with regard to the total of its category. But I want it to show the percentage over Total Income's value. So the chart shown above would have both bars filled with 50% yellow and 50% orange, since the total income is taken in equal parts by the expenses.

I think that maybe in this desired chart things would get weird if total expenses value overcomes total income value (e.g.: total fixed expenses is a value greater than 25.00). So if it's not possible to achieve this desired chart as a Percent Stacked chart, is there some other way to get it without percentages, but still with stacked values?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-06-15 18:39:01 +0200

estevaog3 gravatar image

I managed to get my desired chart by adding colums to hold the percentage values. The result is shown in the following figure: image description

edit flag offensive delete link more

answered 2020-06-15 11:18:39 +0200

newbie-02 gravatar image

would it cover your needs just to delete the row with 'total income' from the data ranges, as in attached sample C:\fakepath\250348_testsheet_test01.ods, [double-click on the chart - right click - data ranges - data series - select row - remove],

if you need different construction - e.g. percentages to another basic value - you can achieve most of it with 'helper cells' calculating temporary values ...

edit flag offensive delete link more


Actually if I remove 'total income' row from the chart than I don't have the percentage over 'total income'. Instead, what I would get is the percentage over sum of expenses. Can you see the difference? If not, consider this example. Say the total income is 100, and expenses (fixed and variable) are equal to 20 both. Than the chart should show 20% for both expenses and 60% for the remaining income.

estevaog3 gravatar imageestevaog3 ( 2020-06-15 17:48:39 +0200 )edit

Thanks for suggesting these temporary values, I didn't know it, I'll take a look at it.

estevaog3 gravatar imageestevaog3 ( 2020-06-15 17:49:32 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-15 05:49:43 +0200

Seen: 186 times

Last updated: Jun 15 '20