Chart Sizing

[Karen]

Using Excel 2000 - Is there a way of sizing a chart to an
exact size instead of grabbing the sizing handles to size
it?

Thank you

 

[Andy Pope]

Hi Karen,

If you select the chart whilst holding the CTRL key you can then set the
width and height via the format dialog.

Cheers
Andy

 

[Karen]

-----Original Message-----
Hi Karen,

If you select the chart whilst holding the CTRL key you can then set the
width and height via the format dialog.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.
Good morning Andy and thank you for your quick response -

It works great - Thank you

 

[Jon Peltier]

Also, if you hold down the ALT key while dragging, the chart will line
up with the cell borders.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______