If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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)? |
#2
|
|||
|
|||
Price & Volume: Secondary X axis Question
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)? . |
#3
|
|||
|
|||
Price & Volume: Secondary X axis Question
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)? . |
Thread Tools | |
Display Modes | |
|
|