ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   create chart /table excel-save, close & reopen colors change? Why (https://www.excelbanter.com/charts-charting-excel/97438-create-chart-table-excel-save-close-reopen-colors-change-why.html)

Anne

create chart /table excel-save, close & reopen colors change? Why
 
When I create a chart/table in Excel - save, close & reopen to use again, the
colors have changed for my formating.

How do I set the formating so that the colors stay the same - I have tried
styles with no luck. The colors need to be the company approved.

Thank you,

HEK

create chart /table excel-save, close & reopen colors change? Why
 
Anne, I am unable to reproduce yr problem. Excel should NOT override yr
manual settings. However,you can set yr company colours as default under
Tools/Options/[Color tab]. Here are the colours Excel uses by default for
the workbook. (Under that thin line you see the defaults for fill and line
colours.)
Hope this helps anyway.
GL, Henk

"Anne" wrote:

When I create a chart/table in Excel - save, close & reopen to use again, the
colors have changed for my formating.

How do I set the formating so that the colors stay the same - I have tried
styles with no luck. The colors need to be the company approved.

Thank you,



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com