The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Pie Chart categorical data
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  2:15:16 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 10 Pro x64

Greetings!

I have a column of categorical data:


How do I make a pie chart of the data?

Thank you.

---
Andrey

snowli

USA
1454 Posts

Posted - 05/17/2022 :  2:25:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You will have to select Statistics: Descriptive Statistics: Discrete Frequency and then plot pie from the result sheet.

Thanks, Snow
Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  2:31:04 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

You will have to select Statistics: Descriptive Statistics: Discrete Frequency and then plot pie from the result sheet.

Thanks, Snow



Dear Snow,

Great suggestion!
How do I disable adding column letter + "''" to the results of Statistics: Descriptive Statistics: Discrete Frequency?
See the following screenshot:


---
Andrey

Edited by - AKazak on 05/17/2022 2:40:51 PM
Go to Top of Page

snowli

USA
1454 Posts

Posted - 05/17/2022 :  2:38:51 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

What would you like to show? Short name or long name?

I am not sure yet if there is a way.

BTW, u can add a new column and enter 1 as F(x) so each row is filled with 1.
Then highlight that column and plot Pie chart directly.

Thanks, Snow
Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  2:42:50 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Hi Andrey,

What would you like to show? Short name or long name?

I am not sure yet if there is a way.


Thanks, Snow



I want to show just Sample Name in the Comments row (see above).

---
Andrey
Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  2:48:20 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Related question: is there a way to automatically create the wedge labels such that counts are located outside the webge, but categories are inside?

---
Andrey
Go to Top of Page

snowli

USA
1454 Posts

Posted - 05/17/2022 :  3:02:53 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I jiraed it to give more identifier control ORG-25242 right now we auto generate it.

Thanks, Snow

quote:
Originally posted by AKazak

quote:
Originally posted by snowli

Hi Andrey,

What would you like to show? Short name or long name?

I am not sure yet if there is a way.


Thanks, Snow



I want to show just Sample Name in the Comments row (see above).

---
Andrey

Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  3:06:06 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Few related questions.

Is there a way to automatically create the wedge labels such that counts are located outside the webge, but categories are inside?

How do I set semitransparent background for the wedge labels to make them visible on top of the wedges themselves?

Thank you.

---
Andrey
Go to Top of Page

snowli

USA
1454 Posts

Posted - 05/17/2022 :  3:14:09 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

I jiraed this in ORG-25242 for future improvements since right now we auto generate the comments.


Thanks, Snow

quote:
Originally posted by snowli

I jiraed it to give more identifier control ORG-25242 right now we auto generate it.

Thanks, Snow

quote:
Originally posted by AKazak

quote:
Originally posted by snowli

Hi Andrey,

What would you like to show? Short name or long name?

I am not sure yet if there is a way.


Thanks, Snow



I want to show just Sample Name in the Comments row (see above).

---
Andrey



Go to Top of Page

snowli

USA
1454 Posts

Posted - 05/17/2022 :  3:20:32 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Right now multiple labels e.g. counts + categories will show together.
U can plot the same data twice in same graph.
For one plot, on Labels tab of PD, set the label to be Counts and set Position to be Associate with Wedge. Outside End.
And to the 2nd plot, set the label to be Categories and set Position to be Associated with Wedge, Center.

Wedge label is on top of wedge. So I don't fully understand what you meant by "semitransparent background for the wedge labels"

quote:
Originally posted by AKazak

Few related questions.

Is there a way to automatically create the wedge labels such that counts are located outside the webge, but categories are inside?

How do I set semitransparent background for the wedge labels to make them visible on top of the wedges themselves?
When label is inside wedge. If u set label color to auto, it will auto decide the label color. E.g. for darker wedge, the label will be white.

Thank you.
Snow

---
Andrey

Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  3:29:21 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli
Wedge label is on top of wedge. So I don't fully understand what you meant by "semitransparent background for the wedge labels"



Please see an example below:


---
Andrey
Go to Top of Page

snowli

USA
1454 Posts

Posted - 05/17/2022 :  3:41:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Right click one label and choose Properties. Set as follows


Thanks, Snow
Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/17/2022 :  10:02:44 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Right click one label and choose Properties. Set as follows
Thanks, Snow



This works fine with a single label.
How do I apply the settings to all the labels at once?

---
Andrey
Go to Top of Page

Cecilia_syy

67 Posts

Posted - 05/18/2022 :  05:23:19 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,
In Snow's screenshot, you can see she set apply to plot in left-bottom of dialog. Then it will apply to all labels for same plot.

I just want to let you know, with a categorical X column, you just need to add one Y column with all value to be 1(set f(x) to be 1), then plot this XY as Pie.

Thanks
Cecilia
Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 05/18/2022 :  06:45:15 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by Cecilia_syy

Hi Andrey,
In Snow's screenshot, you can see she set apply to plot in left-bottom of dialog. Then it will apply to all labels for same plot.

I just want to let you know, with a categorical X column, you just need to add one Y column with all value to be 1(set f(x) to be 1), then plot this XY as Pie.

Thanks
Cecilia



Got it.
Thank you!

---
Andrey
Go to Top of Page

snowli

USA
1454 Posts

Posted - 11/11/2022 :  12:20:48 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

This is also implemented in 2023 official build.

Thanks, Snow

quote:
Originally posted by AKazak

quote:
Originally posted by snowli

Hi Andrey,

What would you like to show? Short name or long name?

I am not sure yet if there is a way.


Thanks, Snow



I want to show just Sample Name in the Comments row (see above).

---
Andrey

Go to Top of Page

AKazak

Russia
1235 Posts

Posted - 11/13/2022 :  05:25:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Hi Andrey,

This is also implemented in 2023 official build.

Thanks, Snow



Dear Snow,

Great news!
I will report here if find issues with this.

---
Andrey
Go to Top of Page

snowli

USA
1454 Posts

Posted - 11/20/2022 :  2:22:08 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Is there a way to automatically create the wedge labels such that counts are located outside the webge, but categories are inside?

Unfortunately we put them together.
E.g. in Plot Details, go to Labels tab, check Value to and percentages so both show.
Or u can check Custom to change the display, e.g. not using () around percentage, etc.

They will show together.

One workaround is plot the same plot again.
For 1st plot, set label to show Counts with Position set to Outside End in Plot Details.
For 2nd plot, set label to show Percentage and Position: Center.

Thanks, Snow
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000