Yet another Excel question.

[Taff]

I always thought I was pretty handy on Excel, but this is now getting embarrassing.

I've been working on about 7 graphs all morning. I've managed to format the first graph exactly as we want it - right size and colour title, right layout, background colour etc. It took about 10 mins to format the first one, which is ok but I don't fancy spending 10 mins each on the other 6, especially if I can click a button.

I have a vague recollection from a training course that there is a way of automatically copying the format from one graph to another.

Anyone know how to do it?

 

[hops]

google

throws this option up

 

[Taff]

Thanks Hops.

I'll give that a crack when I get back to the office tomorrow.

 

[Boxerboy55]

Once I have my first chart all formatted super dooper, I simply copy it then edit the copy to change the Source Data. Repeatedly.

 

[Toad]

I'll pop this over in to the Computer Help section