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
|
|||
|
|||
How can I change the color of negative bubble in bubble chart
Actually, you have to define your second color, click OK twice, so the
series displays the gradient, then double click the series again,on the patterns tab, select the fill for positive values, and hit OK. (The series must actually display the gradient for a moment in order to remember the second color). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message news:... Double click on the series, on the Patterns tab, click Fill Effects, on the Gradient tab, choose the Two Colors option, then select what you want for color 2 (color 1 is what you already selected for the series color). Click OK, then on the Patterns tab, select again the color you want for the positive bubbles (wiping out the gradient in the Sample box). Click OK. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... I find it impossible to change the color of negative bubble into any color other than the default white. Could anyone tell me how to change, or it is not changable? Thanks! |
Thread Tools | |
Display Modes | |
|
|