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
Sorting by this would then give you the desired order.![]()
((Activesheet.chartobjects(1).topleftCell.row-1) * Activesheet.columns.count) + Activesheet.chartobjects(1).topleftCell.column
Bookmarks