Excel 2007 : No option to size chart with window frame? Cant get charts to fit widescreen monitor!

Hi:

This is my first post. I'm good with Excel and I'm testing office 2010 prior to converting everyone across from 2003.

Excel 2003 has an option under Tools/Options/Chart thats called "Chart Sizes With Window Frame". Using this on chart worksheets makes the chart fill the users screen. Handy as it looks right on everyones monitor and most of our more complex charts are far easier to look at on widescreen monitors.

Using Excel 2010 the charts ocupy a small chunk in the middle of the widescreen display, wasting the additional screen width. Does anyone know how to get the same effect as the old "Chart Sizes With Window" option?

Anyone know?

A cheat that works for me in Excel 2007, Generate your chart as usual, scroll to the bottom edge, bring the bottom edge up making a very wide but thin chart horizontally, go to view on the ribbon and set view to fit. then drag bottom edge down to where you want it.
You will probably have to tweak your axis a bit to make it look right.

2010 Office has a new Print Preview mode. Perhaps is you do a File Print of just the chart it will be large like you are used to?
Here is the marketing stuff for 2010 Excel
http://office.microsoft.com/en-us/ex...9709.aspx#BM6a