Apache OpenOffice Community Forum

I am trying to Generate a pie chart with the following field.



It should show 3/4 as one section marked AD and 1/4 as another section marked SUP. I have tried in both Excel and OpenOffice and can't figure out how to make it do this. Any help would be appreciated.

I don't think you can do that directly (but I may be wrong, I'm not a Calc user).
You may have to sum the number of each before creating the chart. That would give 3 for AD and 1 for SUP, then, create the chart based on these figures.

To count the number of entries, you can use the COUNTIF() function for example (see the help file about that function).

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

tomwatson wrote:I am trying to Generate a pie chart with the following field.



It should show 3/4 as one section marked AD and 1/4 as another section marked SUP. I have tried in both Excel and OpenOffice and can't figure out how to make it do this. Any help would be appreciated.

Use the function COUNTIF() and some reference cells

Set up two cells with the codes , AD and SUP ( in my example in F2 and F3)

Assuming data is in A2:A5 then
=COUNTIF(A2:A5;F2) # Gives you the number of AD's
=COUNTIF(A3:A6;F3) # Gives you the number of SUP's

Graph these numbers.

You can also use the Data Pilot (Data > Data Pilot) to do the counting for each value type, and then plot those results.