ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 - Changing properties for Chart on Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/232733-excel-2007-changing-properties-chart-worksheet.html)

Barb Reinhardt

Excel 2007 - Changing properties for Chart on Worksheet
 
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

Excel 2007 - Changing properties for Chart on Worksheet
 
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




Barb Reinhardt

Excel 2007 - Changing properties for Chart on Worksheet
 
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





Jon Peltier

Excel 2007 - Changing properties for Chart on Worksheet
 
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








All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com