YTD Symbol Profit % chart on Overview tab - loses color formatting

fbleitao

Every time I open the workbook the "YTD Symbol Profit %" chart in the Overview worksheet loses the color formatting for the negative columns.

The negative columns appear with a white background as in the picture below:



Does this happen to somebody else?

Thanks!

VidasMatelis

Yes, I have the same issue. I believe it is Excel bug, but I never investigated.

buddyb

Happy New Year to all !!

It looks like you can dress up your chart by doing this:



Pick the color fill patterns for positive or negative bars.



Save your workbook.

BuddyB

Luc

You save your workbook and when you open your workbook again, the color is white again. Excel don't save the 2 color settings, it saves only one color

buddyb

Hmm. I made the graphics change to one of my files. Before posting my previous comment, I closed and re-opened my test file, and colors were still as I reset them. I'm still on Excel 2010, so I still have the ability to edit my PowerPivot stuff. It seems odd, but perhaps that is the difference between what I'm seeing, and what Luc is seeing after he tries resetting his plot colors.



Buddyb

Luc

I am using Microsoft Office Home and Student 2013, I don't have the Power Pivot add-in, and after saving and closing the workbook, and re-opening the workbook, the second color is not selected anymore, I suppose Excel never "saves" the selected color.

Luc

Instead of "Solid fill" you can select "Pattern fill" and then using Foreground and Background colors, save your workbook, reopen it and the colors are shown. It works for me in Excel 2013.

buddyb

Good one Luc,

I was just about to post this link:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/option-invert-if-negative-does-not-show-the/81ad2834-a718-40d6-9990-660f1a1692f4
buddyb