Own scheme of colours in autoformat diagram

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Helen

The schemes found under Format>Autoformats 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing in black & white, most visio diagrams are in colour 1
Can I put text inside venn diagrams in powerpoint? 5
XL 2003 Customize AutoFormat 1
A hard one - How to edit screen tip in colour palette? 1
Excel autoformatting dates 1
Same theme, two colour schemes 2
How do I rotate a triangle diagram shape. 1
Colour Banding in pivot tables 1

Back
Top