Adding Chart Changes Background Color in Entire Workbook

[uncled]

I'm totally baffled!!! I run windows with the background color of light gray (changed from default of white). This makes the background of Excel worksheets gray color. I've got a workbook that whenever I add a Chart in it's own worksheet, the entire workbook background color changes back to the white color.

This doesn't occur if the chart is embedded into an existing worksheet...only when I create in it's own worksheet.

I do have conditional formatting throughout the workbook, but can't for the life of me believe this is causing the problem. However, if I create a new workbook and quickly create a chart based upon a simple table, this issue doesn't occur.

Anyone ever encounter such behaviour?

thanks,
-ed

 

[JPaules]

Try this:

"On the chart types dialog go to the Custom Types tab. Select the User-defined option button. Add your formatted chart to the list. Now you can use the set as default."

--
JP

 

[uncled]

Thanks JP for the response. After much searching the document (and virus scanning just in case) I discovered that I somehow modified the Color palette in that workbook. Fixed the issue by just resetting the palette to the defaults.

Can't for the life of me figure out how I managed to change the palette, but I'm glad it wasn't a corrupt file issue!