Hi molson,
A similar question recently came up. See post number 4 in:
http://www.excelforum.com/excel-char...ml#post3552155
The macro may point you in the correct direction solve your problem. That post was for line charts, however. If you can post a sample workbook, we may be able to better solve your problem.
Lewis
Bookmarks