Excel 2007 - Changing properties for Chart on Worksheet

[Barb Reinhardt]

How do I change the properties for a charts that are displayed on a
worksheet. I'd like to set it up so that it doesn't resize, but moves and I
just can't find where to change it. Can someone assist?

Thanks,
Barb Reinhardt

 

[Jon Peltier]

Barb -

On the Chart Tools > Format tab > Size group, click the strange little
symbol to the right of the group label ("Size"). This opens up a familiar
dialog, and what you want is on the Properties tab.

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

 

[Barb Reinhardt]

Thanks a bunch, Jon. Could they make it harder to find than that??? No,
don't answer that.

 

[Jon Peltier]

They spent a lot of time hiding the items for the scavenger hunt. My
favorite is looking under Paste Special to find Copy as a Picture. I use
that very often, but in 2007 I hadn't found it after months of use. Someone
had to show me where it was. (I was tabbing over to the VB editor and
writing the code in the immediate window!)

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______