Prevent Excel Chart Data Labels overlapping
- by Nicholas
I have an Excel dashboard with line charts containing data labels. Specifically, we are only using the data labels at the rightmost end of the lines, and the labels consist of the Series name and final value. By changing a dropdown, the dashboard is automatically updated to give 19 different dashboards.
The problem is that we can't work out any way of preventing the labels overlapping.
Everything else on the dashboard can be made to automatically update nicely, except for this.
Can anybody think of a way to do this? E.g. plugin or macro.
