| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Own scheme of colours in autoformat diagram
I want to create my own scheme to apply to diagrams once inserted in Excel
using the autoformat tool. Is this possible? I can't find anything that suggests it is ... Or is this something that could only be achieved with VB scripting? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Own scheme of colours in autoformat diagram
Helen
The schemes found under FormatAutoformats cannot be changed. You can record a macro while you are setting up your worksheet to look as you wish. Pick an autoformat scheme and apply it. You can now change the colors etc. while recording the steps. Gord Dibben MS Excel MVP On Mon, 21 Aug 2006 14:25:02 -0700, Helen in NZ <Helen in wrote: I want to create my own scheme to apply to diagrams once inserted in Excel using the autoformat tool. Is this possible? I can't find anything that suggests it is ... Or is this something that could only be achieved with VB scripting? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the color scheme of the autoformat for table 2? | Excel Discussion (Misc queries) | |||
| My colours in the palette disappear at time when using Excel 2003 | Excel Discussion (Misc queries) | |||
| How can i get autoformat name of range in excelsheet? | Excel Worksheet Functions | |||
| Change the default chart colours | Charts and Charting in Excel | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
Linear Mode
