Please clarity "fixed range" and "as if it was printed"
You are aware that you can format chart axis and set the max and min values
of each one?
Or do you mean you want the chart to have a certain size? If so, see
http://peltiertech.com/Excel/ChartsH...oveAChart.html
Need help with VBA, see David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dreamstar_1961" wrote in message
...
Is it possable to make a chart with a fixed range on the side and bottom
as
if it was printed? if so how do we do it, I'm using office 2007 but also
have
2003 on a second machine.