Forum

Notifications
Clear all

Charts - Invert if negative with Pattern Fill - can't change color on the same pattern

2 Posts
2 Users
0 Reactions
68 Views
(@radusirbu)
Posts: 1
New Member
Topic starter
 

Hi,

I choose "pattern fill" for my data series formatting. For the "foreground"  I choose "red" color. I notice that , for "Invert if negative", Excel doesn't let me to choose another color and keep the same pattern like it does if I would have chosen "Solid fill".

Any workaround for this problem? For invert if negative I want to keep the same pattern, but to able to change the color.

Thanks in advance!

 
Posted : 17/12/2018 8:49 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Radu

Not too clear about your formatting requirement. Is it using same patterns with different colors for positive and negative?

See if this is helps. I have created 2 series and filled them with patterns.

Otherwise maybe you can share with us your file with your expected result.

Sunny

 
Posted : 17/12/2018 11:58 pm
Share: