Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 0 down vote accepted

You might look at John Peltier's page on this topic: http://peltiertech.com/Excel/Charts/LabelLastPoint.html

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.