vba code to create chart and fix the axis of the chart

Hi All,

i am creating chart with the help of macro.
every time data changes( values and number of rows and columns)
whenever there is less then 3 row data chart changes its axis, and i have to switch row/column.
Please help how to get rid of this problem.
Below is the code

Please Login or Register  to view this content.