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

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...00906ACNJ.html

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



"Barb Reinhardt" wrote in message
...
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

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

"Jon Peltier" wrote:

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...00906ACNJ.html

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



"Barb Reinhardt" wrote in message
...
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

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...00906ACNJ.html

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


"Barb Reinhardt" wrote in message
...
Thanks a bunch, Jon. Could they make it harder to find than that??? No,
don't answer that.

"Jon Peltier" wrote:

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...00906ACNJ.html

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



"Barb Reinhardt" wrote in
message
...
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