Hi all of you,

I would have one question regarding charts formatting and I would be very grateful if you could help me out with this issue.

The situation is quite simple:

- I've got a sheet with several charts that are updated whenever the user clicks on the sheet (activates the sheet) containing these charts
- The charts are linked to the data sets located in other sheets within the same workbook

- The problem occurs if the users fills the data that are too high. In this case, data labels in the charts overlap each other, so that they are not legible.

Would any of you had a suggestion how to make the data labels in Excel charts dynamic in size, so that they get small in case of large number and bigger in case of small numbers?

Sounds like a pretty standard problem, but I'm unable to find a solution.

Thanks for any help!