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
 All Forums
 Origin Forum
 Origin Forum
 Pie Chart categorical data

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak Posted - 05/17/2022 : 2:15:16 PM
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
17   L A T E S T    R E P L I E S    (Newest First)
snowli Posted - 11/20/2022 : 2:22:08 PM
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
AKazak Posted - 11/13/2022 : 05:25:29 AM
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
snowli Posted - 11/11/2022 : 12:20:48 PM
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
AKazak Posted - 05/18/2022 : 06:45:15 AM
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
Cecilia_syy Posted - 05/18/2022 : 05:23:19 AM
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
AKazak Posted - 05/17/2022 : 10:02:44 PM
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
snowli Posted - 05/17/2022 : 3:41:00 PM
Right click one label and choose Properties. Set as follows


Thanks, Snow
AKazak Posted - 05/17/2022 : 3:29:21 PM
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
snowli Posted - 05/17/2022 : 3:20:32 PM
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
snowli Posted - 05/17/2022 : 3:14:09 PM
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
AKazak Posted - 05/17/2022 : 3:06:06 PM
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
snowli Posted - 05/17/2022 : 3:02:53 PM
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
AKazak Posted - 05/17/2022 : 2:48:20 PM
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
AKazak Posted - 05/17/2022 : 2:42:50 PM
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
snowli Posted - 05/17/2022 : 2:38:51 PM
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
AKazak Posted - 05/17/2022 : 2:31:04 PM
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
snowli Posted - 05/17/2022 : 2:25:05 PM
You will have to select Statistics: Descriptive Statistics: Discrete Frequency and then plot pie from the result sheet.

Thanks, Snow

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000