The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Reverse size scaling for negative numbers

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by cpiano[/i]
[br]Origin Ver. and Service Release (Select Help-->About Origin): Version: 9.1.0 (64-bit) Sr1
Operating System: Win 7

Hello everyone,
I have a 3D bubble chart. The balls are color-coded based on time of occurrence. The "time of occurrence" column is "text" and I have to make the legend based on "categorical values" so that the dates are shown in it (instead of numbers). This is OK.

The problem is that I need to have the radii scaled based on negative numbers. For example:
-1.58
-2.67
-2.86
-3.03
-2.19
-5
-2.36
-4.5
-2.46

and in this case thee -1.58 should be the biggest ball and the -5 is the smallest ball. Also I need this to be shown in the legend as well. So the ball in front of -1.58 in the legend should be bigger than the ball in front of -5.

Please see the picture. Also, you can download the opj file from the link I provide.

Thank you so much
PS. There is a minor thing I would like to do as well but it's not vital. In the legend there are squares in front of the negative numbers. Is there a way to make them spheres instead of squares?
Thank you
[img]http://www.originlab.com/ftp/forum_and_kbase/Images/date_legend.jpg[/img]
[url]http://www.fileconvoy.com/dfl.php?id=gb1f0e56d66285664999440934921b0adfd466a85a[/url]
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
cpiano	Posted - 01/09/2014 : 3:29:44 PM Origin Ver. and Service Release (Select Help-->About Origin): Version: 9.1.0 (64-bit) Sr1 Operating System: Win 7 Hello everyone, I have a 3D bubble chart. The balls are color-coded based on time of occurrence. The "time of occurrence" column is "text" and I have to make the legend based on "categorical values" so that the dates are shown in it (instead of numbers). This is OK. The problem is that I need to have the radii scaled based on negative numbers. For example: -1.58 -2.67 -2.86 -3.03 -2.19 -5 -2.36 -4.5 -2.46 and in this case thee -1.58 should be the biggest ball and the -5 is the smallest ball. Also I need this to be shown in the legend as well. So the ball in front of -1.58 in the legend should be bigger than the ball in front of -5. Please see the picture. Also, you can download the opj file from the link I provide. Thank you so much PS. There is a minor thing I would like to do as well but it's not vital. In the legend there are squares in front of the negative numbers. Is there a way to make them spheres instead of squares? Thank you http://www.fileconvoy.com/dfl.php?id=gb1f0e56d66285664999440934921b0adfd466a85a
3 L A T E S T R E P L I E S (Newest First)
snowli	Posted - 01/09/2014 : 5:39:11 PM Hello, No problem. Just want to let you know that we will try to improve this in the future so you don't need to use the trick I used. The categorical legend should keep those symbol property settings that are not indexed. https://originlab.jira.com/browse/ORG-10392 Also, with my method, the symbol radii isn't proportional to the values. Is that OK? Thanks, Snow
cpiano	Posted - 01/09/2014 : 5:01:13 PM Hi Snow, Thank you so much. Got it. My apologies there was a problem in the email settings. You're right that you had replied about 10 days ago. Sorry about that. I appreciate it. Thank you so much
snowli	Posted - 01/09/2014 : 4:09:19 PM Hello, I emailed you an opj with this requirement on Dec. 30th. Did you get it? I set the radii column to be categorical and sort the whole worksheet by that column so each radii value will have difference size but not actually propertional to the column values, is it OK? I will email to you again. I used some tricks to make both color and size show as circles. Thanks, Snow OriginLab Corp.

The Origin Forum

Snitz Forums 2000