Price & Volume: Secondary X axis Question

I created a typical price&volume graph. Price/XY,
Volume/Column. I put Secondary Category (X), Category in
order not to break columns.

Q. How could I change Volume's color (on Secondary X
axis) to gradient (two colors)?

right click on the 'volume' data series and
select 'format data series'. On the 'Patterns' tab,
click 'fill effects'. from there you can pick your
gradient colours.

Richard

-----Original Message-----
I created a typical price&volume graph. Price/XY,
Volume/Column. I put Secondary Category (X), Category in
order not to break columns.

Q. How could I change Volume's color (on Secondary X
axis) to gradient (two colors)?
.

Richard -

An off-topic word to the wise. I know it's only a hotmail account, but
if you don't do something to disguise it, you'll be fighting off
mountains of spam in your inbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

right click on the 'volume' data series and
select 'format data series'. On the 'Patterns' tab,
click 'fill effects'. from there you can pick your
gradient colours.

Richard


-----Original Message-----
I created a typical price&volume graph. Price/XY,
Volume/Column. I put Secondary Category (X), Category in
order not to break columns.

Q. How could I change Volume's color (on Secondary X
axis) to gradient (two colors)?
.