34- Libre Office - Calc, Open Office -- Calc, Excel Tutorial -- Pie Chart

Create a simple pie chart, add title, change the colors of the slices of pie, change font in the legend.

[darwin]

im think this dude needs a tv show media needs you badly

[MichaelsTechTutorials]

Thanks for the comment - It's always good to know when my videos are helping someone out. It inspires me to keep making more!

[Bitcoinsorbust]

Even 11 years later its still helpful - Thanks

[DavidBentzonTV]

Thank you dude! Great, accurate and simple tutorial. Just what i needed for my homework!

[yuwan]

Thanks a lot because this video solved my problem of setting colours!

[megsybeth]

This is awesome. Thank you! I'm going to share this with my employees.

[MichaelsTechTutorials]

@DavidBentzonTV Glad I could help - If you are using LibreOffice for your homework, you may want to check out some of my LibreOffice Writer tutorials as well - I use the same format there - explaining how to create a table of content, bibliography and some of the other lesser know features of LibreOffice Writer as well. Thanks for watching!

[Paovgs]

Thank you for the video, it was very helpful

[darwin]

thanks big time, , , , from a parents point this is a big help

[MichaelsTechTutorials]

Your welcome, Thanks for the comment!

[MichaelsTechTutorials]

You can cut (or copy) and paste your pie chart into a writer document. I show this (cut and paste into a different calc sheet) in video #35. You would do the same but paste into your writer document.

[MichaelsTechTutorials]

Sorry to hear that - I don't have a mac, so I can not test it.

I didn't see any issues for that on the LibreOffice bug problems page - But I could have missed it. If it is a big deal to you, you may want to report it - The people that support that have been very polite and helpful to me.

[cgsofficepng]

Thank you for the video format, it's really helpful. now i can do better graph

[MichaelsTechTutorials]

You will have to use the sumif or sumproduct with with the countif.
Something like:

[MichaelsTechTutorials]

I just downloaded the chart that goes with this video. I tried changing the numbers and my pie chart changed for all the numbers. You might try hitting F9 to recalculate or cntl+shft+F9 to recalculate document.

[MichaelsTechTutorials]

Now think I see the problem, you are using Open Office and I am using LibreOffice.

LibreOffice is a fork of Open Office (It's origin is Open Office). But the people at LibreOffice have done a lot of bug fixes over the last few years.

Try downloading the most recent version of LibreOffice and try it again.

You can have both LibreOffice and Open Office on your machine at the same time, you just can't have them both open at the same time.
(or you can try LibreOffice Portable).

[MichaelsTechTutorials]

@thegreattailz Thank you for your comment. I will consider placing a link to Video 35. In the meantime, all my videos can be found in a playlist on my Youtube Channel in order. They can also be found on my website in order and grouped in categories; and some videos have downloads of the .ods files I used in the video for people who would like to do the same exercise I do in the video with the same .ods file I used.

[NiMi]

1:48 but how do we adjust the legend to exclude categories that are 0%? (and thus will not be seen on the pie chart -but for some reason remain on the legend)

[MichaelsTechTutorials]

Download this example from my website – We will add a line for percentages under the numbers.
Lower the chart to show line 9.
In cell G8 place the formula =Sum(B8:F8). 
In cell B9  type in the formula =B8/$G8 then
copy and paste B9 into cells C9, D9, E9, and F9.
Copy and paste G8 into G9. 
Select B9 thru G9 and click the percent sign (on the formatting toolbar)
You're Done!

[MichaelsTechTutorials]

Get your percentage as explained to Christian (below), then in cell B7, instead of saying "Apple" enter the formula =TEXT(B8, "0%") & " - Apple"