Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 23 Dec 2014 17:27:26 +0100I need to create a chart in Calc for two differently sized groups of respondents.https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/The chart is required to be a column one and has to show two columns in a point of the x-axis which, will compare Group A and Group B, for three different variables. The chart also has to show the figure and the percentage value, the latter of which proved to be a bit complicated. Any ideas?
To sum up, the requirements are:
1) Three variables on the x-axis for two groups of respondents
2) Column chart
3) Show figure
4) Show percentage
5) Have two columns for each variable, one for each group
6) 100% for Group A is 50 respondents
7) 100% for Group B is 56 respondents
8) The percentage shown represents the proportion of the given group voting for the given variable
[![Screenshot: the percentage is wrong](http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png)](http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png)Tue, 23 Dec 2014 08:04:06 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/Answer by pavelktomas for <p>The chart is required to be a column one and has to show two columns in a point of the x-axis which, will compare Group A and Group B, for three different variables. The chart also has to show the figure and the percentage value, the latter of which proved to be a bit complicated. Any ideas?</p>
<p>To sum up, the requirements are:</p>
<p>1) Three variables on the x-axis for two groups of respondents
2) Column chart
3) Show figure
4) Show percentage
5) Have two columns for each variable, one for each group
6) 100% for Group A is 50 respondents
7) 100% for Group B is 56 respondents
8) The percentage shown represents the proportion of the given group voting for the given variable </p>
<p><a href="http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png"><img alt="Screenshot: the percentage is wrong" src="http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png"/></a></p>
https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?answer=43973#post-id-43973Thank you for your reply. The problem is that the task is to have two columns for each. I tried to offer this solution, but it is necessary to have two columns. I even tried to add two axes with two different max levels, but then the percentage value is 100% everywhere.
[![Screenshot: two axes](http://s9.postimg.org/9trc724xr/Sn_mek_z_2014_12_23_08_59_49.png)](http://s9.postimg.org/9trc724xr/Sn_mek_z_2014_12_23_08_59_49.png)Tue, 23 Dec 2014 09:03:10 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?answer=43973#post-id-43973Answer by ROSt52 for <p>The chart is required to be a column one and has to show two columns in a point of the x-axis which, will compare Group A and Group B, for three different variables. The chart also has to show the figure and the percentage value, the latter of which proved to be a bit complicated. Any ideas?</p>
<p>To sum up, the requirements are:</p>
<p>1) Three variables on the x-axis for two groups of respondents
2) Column chart
3) Show figure
4) Show percentage
5) Have two columns for each variable, one for each group
6) 100% for Group A is 50 respondents
7) 100% for Group B is 56 respondents
8) The percentage shown represents the proportion of the given group voting for the given variable </p>
<p><a href="http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png"><img alt="Screenshot: the percentage is wrong" src="http://s14.postimg.org/sutvxz6y9/Sn_mek_z_2014_12_23_07_56_51.png"/></a></p>
https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?answer=43971#post-id-43971When it comes to percentage values the main question is what is 100%.
I assume that the sum of two values for each variable is 100%. The the chart should look like:
![image description](/upfiles/14193203028669951.png)
In each column each data point contains 2 figures: Top is absolute value and bottom is the percentage value.
If this is the chart you need, I recommend to do the following:
Double click you chart until you see 6 black little squares in a greyu frame.
Right click somewhere in the chart > chart type > select top right
Click once into a data point an all data points of the same group show green squares
Right click into the data point > Format data labels > tab: data labels > check show values and percentage > adjust the format > OK
a bit lower: Seperator > select what you want, I selected new line > OK
If my assumption with the 100% value is wrong, please explain the situation.
I recommend to have a look at the free guides which you can download from http://www.libreoffice.org/get-help/documentation/
EDIT:
Let me start from the end - the 100% question. Possibilities are
- in each var the sum of group1 + group2 is 100% (this is what I used in my example)
- in each group the sum of var1+var2+var3 = 100% (then my assumption is wrong but then your example is also wrong)
- the value for combination of var and group is a percentage figure which does not add up with one or more of the given figures to be 100% (then all must be considered differently)
Each group can be differentiated by color. You can actually give each data point a different color. Once in the editing mode of the chart (6 little black squares around in a grey frame) you need to double click in a data point and you can modify the color of each single datapoint analog to the color setting for a series for data points
Two colums per group is not possible. Per group you have 3 var. Or you want to have 2 columns per var, one column for ich group. But with 2 colums per var beside each other you might need to recalculate your percentage values
I recommend strongly that you clearly define what is 100%. Otherwise i have to make to many assumptions.
Tue, 23 Dec 2014 08:47:54 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?answer=43971#post-id-43971Comment by ROSt52 for <p>When it comes to percentage values the main question is what is 100%.</p>
<p>I assume that the sum of two values for each variable is 100%. The the chart should look like:</p>
<p><img alt="image description" src="/upfiles/14193203028669951.png"/></p>
<p>In each column each data point contains 2 figures: Top is absolute value and bottom is the percentage value.</p>
<p>If this is the chart you need, I recommend to do the following:</p>
<p>Double click you chart until you see 6 black little squares in a greyu frame.</p>
<p>Right click somewhere in the chart > chart type > select top right </p>
<p>Click once into a data point an all data points of the same group show green squares</p>
<p>Right click into the data point > Format data labels > tab: data labels > check show values and percentage > adjust the format > OK</p>
<p>a bit lower: Seperator > select what you want, I selected new line > OK</p>
<p>If my assumption with the 100% value is wrong, please explain the situation.</p>
<p> I recommend to have a look at the free guides which you can download from <a href="http://www.libreoffice.org/get-help/documentation/">http://www.libreoffice.org/get-help/d...</a></p>
<p>EDIT: <br/>
Let me start from the end - the 100% question. Possibilities are <br/>
- in each var the sum of group1 + group2 is 100% (this is what I used in my example) <br/>
- in each group the sum of var1+var2+var3 = 100% (then my assumption is wrong but then your example is also wrong) <br/>
- the value for combination of var and group is a percentage figure which does not add up with one or more of the given figures to be 100% (then all must be considered differently)</p>
<p>Each group can be differentiated by color. You can actually give each data point a different color. Once in the editing mode of the chart (6 little black squares around in a grey frame) you need to double click in a data point and you can modify the color of each single datapoint analog to the color setting for a series for data points</p>
<p>Two colums per group is not possible. Per group you have 3 var. Or you want to have 2 columns per var, one column for ich group. But with 2 colums per var beside each other you might need to recalculate your percentage values</p>
<p>I recommend strongly that you clearly define what is 100%. Otherwise i have to make to many assumptions. </p>
https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43993#post-id-43993see EDIT in my answerTue, 23 Dec 2014 17:27:26 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43993#post-id-43993Comment by pavelktomas for <p>When it comes to percentage values the main question is what is 100%.</p>
<p>I assume that the sum of two values for each variable is 100%. The the chart should look like:</p>
<p><img alt="image description" src="/upfiles/14193203028669951.png"/></p>
<p>In each column each data point contains 2 figures: Top is absolute value and bottom is the percentage value.</p>
<p>If this is the chart you need, I recommend to do the following:</p>
<p>Double click you chart until you see 6 black little squares in a greyu frame.</p>
<p>Right click somewhere in the chart > chart type > select top right </p>
<p>Click once into a data point an all data points of the same group show green squares</p>
<p>Right click into the data point > Format data labels > tab: data labels > check show values and percentage > adjust the format > OK</p>
<p>a bit lower: Seperator > select what you want, I selected new line > OK</p>
<p>If my assumption with the 100% value is wrong, please explain the situation.</p>
<p> I recommend to have a look at the free guides which you can download from <a href="http://www.libreoffice.org/get-help/documentation/">http://www.libreoffice.org/get-help/d...</a></p>
<p>EDIT: <br/>
Let me start from the end - the 100% question. Possibilities are <br/>
- in each var the sum of group1 + group2 is 100% (this is what I used in my example) <br/>
- in each group the sum of var1+var2+var3 = 100% (then my assumption is wrong but then your example is also wrong) <br/>
- the value for combination of var and group is a percentage figure which does not add up with one or more of the given figures to be 100% (then all must be considered differently)</p>
<p>Each group can be differentiated by color. You can actually give each data point a different color. Once in the editing mode of the chart (6 little black squares around in a grey frame) you need to double click in a data point and you can modify the color of each single datapoint analog to the color setting for a series for data points</p>
<p>Two colums per group is not possible. Per group you have 3 var. Or you want to have 2 columns per var, one column for ich group. But with 2 colums per var beside each other you might need to recalculate your percentage values</p>
<p>I recommend strongly that you clearly define what is 100%. Otherwise i have to make to many assumptions. </p>
https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43974#post-id-43974Thank you for your reply. The problem is that the task is to have two columns for each. I tried to offer this solution, but it is necessary to have two columns. I even tried to add two axes with two different max levels, but then the percentage value is 100% everywhere.
Also, the groups must be differentiated by the same colours.
[![Screenshot: two axes](http://s9.postimg.org/h9qlsusmz/Sn_mek_z_2014_12_23_08_59_49.jpg)](http://s9.postimg.org/9trc724xr/Sn_mek_z_2014_12_23_08_59_49.png)Tue, 23 Dec 2014 09:04:25 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43974#post-id-43974Comment by pavelktomas for <p>When it comes to percentage values the main question is what is 100%.</p>
<p>I assume that the sum of two values for each variable is 100%. The the chart should look like:</p>
<p><img alt="image description" src="/upfiles/14193203028669951.png"/></p>
<p>In each column each data point contains 2 figures: Top is absolute value and bottom is the percentage value.</p>
<p>If this is the chart you need, I recommend to do the following:</p>
<p>Double click you chart until you see 6 black little squares in a greyu frame.</p>
<p>Right click somewhere in the chart > chart type > select top right </p>
<p>Click once into a data point an all data points of the same group show green squares</p>
<p>Right click into the data point > Format data labels > tab: data labels > check show values and percentage > adjust the format > OK</p>
<p>a bit lower: Seperator > select what you want, I selected new line > OK</p>
<p>If my assumption with the 100% value is wrong, please explain the situation.</p>
<p> I recommend to have a look at the free guides which you can download from <a href="http://www.libreoffice.org/get-help/documentation/">http://www.libreoffice.org/get-help/d...</a></p>
<p>EDIT: <br/>
Let me start from the end - the 100% question. Possibilities are <br/>
- in each var the sum of group1 + group2 is 100% (this is what I used in my example) <br/>
- in each group the sum of var1+var2+var3 = 100% (then my assumption is wrong but then your example is also wrong) <br/>
- the value for combination of var and group is a percentage figure which does not add up with one or more of the given figures to be 100% (then all must be considered differently)</p>
<p>Each group can be differentiated by color. You can actually give each data point a different color. Once in the editing mode of the chart (6 little black squares around in a grey frame) you need to double click in a data point and you can modify the color of each single datapoint analog to the color setting for a series for data points</p>
<p>Two colums per group is not possible. Per group you have 3 var. Or you want to have 2 columns per var, one column for ich group. But with 2 colums per var beside each other you might need to recalculate your percentage values</p>
<p>I recommend strongly that you clearly define what is 100%. Otherwise i have to make to many assumptions. </p>
https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43980#post-id-43980Moreover, the suggested solution does not show the percentage of the group that chose the given answer.
I need something like this, but in the two-column variation, so that the percentage adds up to 100%, but shows the two groups:
[![Screenshot: possibility](http://s6.postimg.org/o784a87fx/Sn_mek_z_2014_12_23_11_21_25.jpg)](http://s6.postimg.org/n4xxroomp/Sn_mek_z_2014_12_23_11_21_25.png)Tue, 23 Dec 2014 11:26:17 +0100https://ask.libreoffice.org/en/question/43968/i-need-to-create-a-chart-in-calc-for-two-differently-sized-groups-of-respondents/?comment=43980#post-id-43980