How to control the color of volume bar in a price-volume chart

[macrofan]

I have created <NOBR>a stock</NOBR> price-volume chart, in which the volume section is a bar chart. The color of the volume bar will be either green or red depending on the price increase or decrease relative to the previous close. My question is how to control the color of individual bars in corresponding to the changes in the price.

Thanks.

 

[Gerald Higgins]

Use two separate data series, with separate areas of your worksheet providing data for each series.

For example, if A1:A10 contains your increase or decrease data....

In B1

=if(A1>0,A1,0)

and in C1

=if(A1<0,A1,0)

Copy B1 and C1 down to row 10.

Then set up a stacked bar chart with two data series, one driven by B1:B10 and one by C1:C10.
Make one series red, the other one green.