It did not work. There may be some trick with it but I
couldn't find it either.
OK let me explain a bit more.
Category data is one year date, yet, it is not 365 days.
Some skipps here and there throughout, therefore, there
is a space among columns accordingly. I am trying to fill
the space out by creating secondary X axis. (I hope I am
doing right.)
By doing so, I can successfully fill the space by making
a bit of change (making weight thiker, etc.) But I don't
know how to make the area (that is a plot area without
secondary X axis) gradient.
Thanks.
-----Original Message-----
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)?
.
.