Chart Labels
I apologize for double-posting, but I didn't know the best
place to ask this... I have a series of pie charts that are updated via a macro. When the data is changed, the labels on these charts move around (and we know how Excel default labels line up). I need a way to fix them so they are readable. Is there any way to do that automatically? Office 2K, Windows 2K Thanks Erin .. |
Chart Labels
Wish I knew - I have the same frustration. I have found
no "automatic" way to do this. In theory it should be possible to write a VBA routine that sets the position of the data labels, but I have not yet figured out the logic to determine how to position them. If I ever get a useful routine built I will try to remember to let you know (at least post it here). -----Original Message----- I apologize for double-posting, but I didn't know the best place to ask this... I have a series of pie charts that are updated via a macro. When the data is changed, the labels on these charts move around (and we know how Excel default labels line up). I need a way to fix them so they are readable. Is there any way to do that automatically? Office 2K, Windows 2K Thanks Erin .. . |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com