ChartDirector Support - View Thread 1333300792

Re: best graphic for this

Posted by Peter Kwan on Apr-03-2012 00:37

Hi Leo,

I have some difficulty understanding what the data mean, so it is hard for me to suggest.

Do the magnitude of the LHS number matter? I realize it is always +1 or -1 in your sample data. If it is really a ratio, then the LHS should not matter, and only the entire ratio LHS/RHS matter, and the magnitude of the ratio is determined only by the RHS (as the LHS is always 1 or -1). If it is really the ratio that matter, then what is the purpose of the +/- in LHS and RHS. Is +1:-35 the same as -1:+35?

If it is really just a ratio, I suggest you can plot the RHS only, and choose a postive value if the ratio is positive, and a negative value if the ratio is negative.

Regards
Peter Kwan

Re: best graphic for this

Posted by Leo on Apr-03-2012 04:57

>Do the magnitude of the LHS number matter?
yes

>Is +1:-35 the same as -1:+35?
No.

+1:-35 is for every $1 increase in retained earnings, there is a decrease of $35 in
price.

-1:+35 is for every $1 decrease in retained earnings, there is an increase of $35 in
price.

Both ratio as a whole is -35, but it meant different animals. Since prices' sensitivities
to negative and positive changes in retained earnings are different.

Peter, how do you control individual color of each bar of a bar chart?

Thanks.

Peter Kwan wrote:

Hi Leo,

I have some difficulty understanding what the data mean, so it is hard for me to
suggest.

Do the magnitude of the LHS number matter? I realize it is always +1 or -1 in your
sample data. If it is really a ratio, then the LHS should not matter, and only the entire
ratio LHS/RHS matter, and the magnitude of the ratio is determined only by the RHS
(as the LHS is always 1 or -1). If it is really the ratio that matter, then what is the
purpose of the +/- in LHS and RHS. Is +1:-35 the same as -1:+35?

If it is really just a ratio, I suggest you can plot the RHS only, and choose a postive
value if the ratio is positive, and a negative value if the ratio is negative.

Regards
Peter Kwan

Re: best graphic for this

Posted by Peter Kwan on Apr-04-2012 01:02

Hi Leo,

For controlling bar colors, if there is only a few colors, I suggest you can use mulitple bar layers (or multiple data sets), with each bar layer or data set handles the bars of a particular color. The code structure will be like:

$redBars = [... array of values for red bars - use $perlchartdir::NoValue for positions with no red bars ...];

$greenBars = [... array of values for green bars - use $perlchartdir::NoValue for positions with no green bars ...;

$redBarLayer = $c->addBarLayer($redBars, 0xff0000, ...);
$greenBarLayer = $c->addBarLayer($greenBars, 0x0xcc00, ...);

If you have many colors, you may consider to use a Multi-Color Bar Chart. See the sample code "Multi-Color Bar Chart" (you may look it up from the ChartDirector documentation index).

For the data representation, if the LHS is always 1 or -1, then the absolute value "1" is really not important, and the only information on the LHS is the sign. You may consider to just plot the ratio itself as a bar chart (so -1:+35 and +1:-35 will both be plotted as -35), and use the color of the bar to represent the sign of the LHS. The -35 bar can be visualize to mean that the price moves opposite to retained earnings in both cases, and the color represents whether the ratio is computer based on positive or negative change in retained earnings.

Regards
Peter Kwan

Re: best graphic for this

Posted by Leo on Apr-04-2012 09:47

Great! Thanks!