I know this sounds stupid, but I need to know the actual height of a single Legend-Entry.
In my chart the height changes, depending on the Legend-Entries on the right side of the chart.
1 countLegend = ActiveChart.Legend.LegendEntries.Count
2 If countLegend > 13 Then
3 ActiveChart.Parent.Height = 325 + 10 * (countLegend - 13)
5 ActiveChart.Parent.Height = 325
6 End If
The "10" at line 3 is the current solution, but if I add too many Legend-Entries there would be a big space above and underneath...
I hope someone can help me with this problem...
Thank you very much in advance for your answers...