3D chart-% data no show outside each segment

Discuss the spreadsheet application

3D chart-% data no show outside each segment

Postby no middle name » Thu Apr 04, 2019 6:24 am

Hello all.

I am constructing a 3D graph.

I have successfully solved part of a problem, and the addition and calculation of percentage of total, separately, for each of 6 components.

For some reason, I am unable to have the calculated percentages for each of the segments show outside the segment. I suspect that this is a chart element issue, but can’t be sure. Any ideas on how to fix this?


Thanks.
LibreOffice 6.2 Windows 7 Home
no middle name
 
Posts: 8
Joined: Sun Mar 31, 2019 6:07 pm

Re: 3D chart-% data no show outside each segment

Postby Zizi64 » Thu Apr 04, 2019 6:53 am

Can you upload your ODF type sample file here?
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8208
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: 3D chart-% data no show outside each segment

Postby no middle name » Thu Apr 04, 2019 9:40 am

Zizi64 wrote:Can you upload your ODF type sample file here?


I have revised the file to make it clearer. It is the 3D chart/graph that I am concentrating on.

Column G in the data file, "% of Total", each of the cell entries is now correct. I had attempted to do the following:

i) G11, both sum G5-G10, and ROUND to 100 in the one formula. This did not work.

ii) With the error removed, the issue of no data showing outside each segment of the 3D chart/graph remains.
Attachments
book sales-bar & 3D.ods
(34.7 KiB) Downloaded 8 times
LibreOffice 6.2 Windows 7 Home
no middle name
 
Posts: 8
Joined: Sun Mar 31, 2019 6:07 pm

Re: 3D chart-% data no show outside each segment

Postby Zizi64 » Fri Apr 05, 2019 10:33 pm

See the modified formulas in the column G and the concatenated textual labels in the column H.
These labels are applied to the legend and as data labels of the graph.

book sales-bar & 3D Zizi64.ods
(26.86 KiB) Downloaded 7 times


(Edited in the LO 6.1.5)
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8208
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: 3D chart-% data no show outside each segment

Postby no middle name » Sat Apr 06, 2019 8:30 am

Thanks very much-much appreciated. Did I read somewhere that you're a lecturer in spreadsheets?

If so, that might explain your very sophisticated formulae.

I am still taking “baby steps” at this stage. Despite my example purportedly of an abbreviated, complex content, it is all relative.

I understand the part about the legend.

I don’t know about the data labels.

What I am trying to create, is like you’ve shown here, but stripped back:

Legend as simple, in a horizontal line, without the percentages, and under Title as shown

And the percentages for all, as shown in your “Cookery 14,74%” label, but without the content description ie. “cookery”, and the percentages rounded up to nearest whole number.

Would there be any simpler formulae?

Thanks again.
LibreOffice 6.2 Windows 7 Home
no middle name
 
Posts: 8
Joined: Sun Mar 31, 2019 6:07 pm

Re: 3D chart-% data no show outside each segment

Postby Zizi64 » Sat Apr 06, 2019 11:14 am

What I am trying to create, is like you’ve shown here, but stripped back:

Legend as simple, in a horizontal line, without the percentages, and under Title as shown

And the percentages for all, as shown in your “Cookery 14,74%” label, but without the content description ie. “cookery”, and the percentages rounded up to nearest whole number.


Just adjust the properties of the graph (data ranges - y values, data labels... etc...)

Right click - Data Ranges - Data series (TAB)
Adjust graph.png


Insert - Data Labels - Data Labels (TAB)
Adjust graph2.png


book sales-bar & 3D Zizi64b.ods
(26.76 KiB) Downloaded 7 times
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8208
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 33 guests