Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to set new default for plot area settings
Hi,
In Excel 2003, how do I set new default value for plot area to Automatic? Now the default is custom, and background colour one that I do not want. I can change the plot area to automatic for a chart I have created, but would like to change the default value so, that whenever creating a new chart, it would have Plot area settings "Border" and "Area" set as automatic. Obviously it should be done within the template Book.xlt, but how? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to set new default for plot area settings
Hi,
You can format a chart and store it as a user defined chart type, which can also be set as the default. http://pubs.logicalexpressions.com/P...cle.asp?ID=299 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "KeepItSimple" wrote in message ... Hi, In Excel 2003, how do I set new default value for plot area to Automatic? Now the default is custom, and background colour one that I do not want. I can change the plot area to automatic for a chart I have created, but would like to change the default value so, that whenever creating a new chart, it would have Plot area settings "Border" and "Area" set as automatic. Obviously it should be done within the template Book.xlt, but how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot area settings... | Charts and Charting in Excel | |||
How do i change the default plot area backgroung color in excel? | Charts and Charting in Excel | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
How do I change the excel chart default plot area color? | Charts and Charting in Excel |