color control in price-volume chart

[macrofan]

I have created a stock 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 change relative to the previous close price. I will appreciaate very much if anybody can show me how to control the color of each individual bar based on the corresponding price changes.

 

[Steve=True]

Yes you can do this.

Basically you create a dummy columns of chart data where you set your condition. One for Red and one for Green

For red column, If condition = Red then = data if not, then = NA()

likewise for green.

Chart the new dummy columns not the original data. In the chart, find the Green series and change its color. Then the same for the red series.

This link will help!

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

 

[macrofan]

Yes you can do this.

Basically you create a dummy columns of chart data where you set your condition. One for Red and one for Green

For red column, If condition = Red then = data if not, then = NA()

likewise for green.

Chart the new dummy columns not the original data. In the chart, find the Green series and change its color. Then the same for the red series.

This link will help!

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Thank you so much for the tips and info! I will try it.
You have a great day!

 

[Steve=True]

http://www.andypope.info/charts.htm

Good samples here too

 

[macrofan]

http://www.andypope.info/charts.htm

Good samples here too

Wow!!!! This is really super great!

Thank you so much!