Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Why don't remove labels and insert a legend? – Toc Feb 4 '11 at 11:08
toc: that's what i recommended. The client wants to see the name and final value right next to the line. – Nicholas Feb 7 '11 at 5:27
up vote 0 down vote accepted

You might look at John Peltier's page on this topic:

share|improve this answer
This is a great resource for marking the last label on a chart. While it won't stop data labels overlapping, I believe there is no established way of doing this, and it would require custom coding. So I'll award this answer. – Nicholas Apr 10 '11 at 23:12
To prevent data label overlapping, one would have to write code that looked for labels that overlapped, then figure out which way to move the labels to reduce or remove the overlap without causing overlap with other labels. I've had a go at it, and it's rather tricky. – Jon Peltier Nov 28 '14 at 16:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .