I guess that you are hoping for charts to be read left to right and then top to bottom. If so, you can get the cell number like this

((Activesheet.chartobjects(1).topleftCell.row-1) * Activesheet.columns.count) + Activesheet.chartobjects(1).topleftCell.column
Sorting by this would then give you the desired order.