In article ,
says...
Can I decide what the graph scale can be and be constant for all the graphs I
want to make for excel data

Assuming the axis of interest supports numeric data, double click the axis
then select the Scale tab. The rest should be self-evident.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions