Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
The plot area default color for excel charts is grey. How do I permanently
make it white? |
#2
![]() |
|||
|
|||
![]()
My preferred choice would be to create a series of different charts with
white plot areas. Store each of these charts as user defined. To do so, click on one of the charts you have just created. Go to the standard toolbar and hit Chart - Chart Type - Custom Types Tab -User Defined. Then select the chart to be your default type. Outside of creating user defined charts, Excel stores charts that are used for the built-in custom chart types in a file called xl8galry.xls. Search your directories until you find the file. You can make formatting changes to this group of charts too although they may not be your default. If you do so make sure to make a copy of the file. Personally, I would leave well enough alone and just use the first suggestion. ---- Regards, John Mansfield http://www.pdbook.com "gg96555" wrote: The plot area default color for excel charts is grey. How do I permanently make it white? |
#3
![]() |
|||
|
|||
![]()
Another alternative is to adjust your color palette. Select Options on
the Tools menu, click on the color tab, and use the Modify button to apply the gray color to the spot on the palette which is now white, and vice versa. Also notice the bottom two rows of the palette are labeled Chart Lines and Chart Fills. If you don't like the default chart series colors (despite their natural attractiveness), you can use Modify to insert colors you prefer. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Mansfield wrote: My preferred choice would be to create a series of different charts with white plot areas. Store each of these charts as user defined. To do so, click on one of the charts you have just created. Go to the standard toolbar and hit Chart - Chart Type - Custom Types Tab -User Defined. Then select the chart to be your default type. Outside of creating user defined charts, Excel stores charts that are used for the built-in custom chart types in a file called xl8galry.xls. Search your directories until you find the file. You can make formatting changes to this group of charts too although they may not be your default. If you do so make sure to make a copy of the file. Personally, I would leave well enough alone and just use the first suggestion. ---- Regards, John Mansfield http://www.pdbook.com "gg96555" wrote: The plot area default color for excel charts is grey. How do I permanently make it white? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change fill color default in excel 2003? | Excel Discussion (Misc queries) | |||
How do I change the default color of the tag for insert c... | Excel Discussion (Misc queries) | |||
How do I change the default color of the tag for insert c... | Excel Discussion (Misc queries) | |||
Default fill color change | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |