Ask Your Question
0

How to generate pie chart out of a single column of data?

asked 2017-10-03 16:47:47 +0200

ePierre gravatar image

updated 2017-10-03 16:48:53 +0200

Hello!

In Calc, I have a set of data such as:

ID  Gender
1   Female
2   Male
3   Male
4   Female
…   …
99  Male

I would like to generate a pie chart out of it that would look like this:

image description

Do I need to create an intermediate table summing the different options I have in the "Gender" column or is there a better, automated solution for this?

(I have other columns with more than two options and I would like to do similar pie charts for these as well)

Thanks in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-03 18:23:35 +0200

Regina gravatar image

I would use Pivot Table for all such kind of data analysis. You can then generate a Pivot Chart from the Pivot Table. In contrast to a normal chart, it adapts automatically in case you use filter.

In this special case mark all data including the column heading. Create Pivot Table from current selection. Drag the "Gender" field to "Row Fields" and to "Data Fields". Double-click "Gender" in the Data Fields and select the function, here Count. Exit Edit Layout mode. Mark the inner cells of the Pivot Table and generate the desired chart.

If you open "Displayed Value" you will notice, that you even can get the percent values. You also can drag "Gender" a second time to the Data Fields and choose a different function or displayed value. But here such works not nice together with the chart.

edit flag offensive delete link more

Comments

Thanks! Exactly what I was looking for. I'll try to learn more about pivot tables.

ePierre gravatar imageePierre ( 2017-10-04 06:33:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-03 16:47:47 +0200

Seen: 1,708 times

Last updated: Oct 03 '17