Data Label Organization in Chart

[terrib1e]

I have a chart that represents 28 different series organized by dates. 3 of the series I have set up as lines, and 3 others set up as transparent areas. I have the remaining 22 set up as bars and I'm having a hard time showing the value and labels of each without them crowding each other. I've reduced the view down to a 2 week period with a scrollbar to go through the year, but it's still pretty crowded depending on the day. I have a legend set up, and I've set up check boxes to turn on and off specific series, but I was wondering if anyone had any other suggestions to better organize and clean up the label positions. I'm open to VBA or any other kind of solution.

I also have an issue with the series name label appearing even in values that have 0. I can make the value 0 disappear using 0;;; but is there a way to include the series name in that?

 

[Worf]

• It is a bit hard without seeing it. Can you post a link to the workbook or a chart picture? Does the page below help?
• Concerning the zero issue, use this code:

Sub DL()
Dim s As Series, x, i%
Set s = ActiveChart.SeriesCollection(1)
x = s.Values
For i = LBound(x) To UBound(x)
    If x(i) = 0 Then s.DataLabels(i).Text = ""
Next
End Sub

http://datapigtechnologies.com/blog/index.php/auto-adjust-chart-label-positions/