Chart Axes Scale Issue

Hi beautiful people,
1- Open enclosed file.
2- Select Sheet1 then run Macro1. (Look at StockChart left axes scales, it is between 14 and 19)
3- Select Sheet2 then run Macro1. (Look at StockChart left axes scales, it is between 0 and 20)

Please Login or Register  to view this content.

4- Be aware that there is a big apparence differences between two charts.

Question: How can I prevent such a big apparence differences between two charts ?


Note: Sheet1 data and Sheet2 data difference coming from only first two rows and last two rows.

Solved.

Please Login or Register  to view this content.