Fewer data labels ?

[MartinGM]

I don't suppose this is possible, but if you don't ask



I have turned on data labels on a simple line chart - that works fine, but . . . there are so many data points that the labels overlap and are unreadable, and more points are added each day.

Is there any way to, for instance, only have a label on alternate data points - or something else that has a similar effect ?

I could construct a second data set, interpolated to have fewer data points, but that is a monumental faff and I have quite a few similar charts to work on.

Thanks in advance for any innovative ideas.

PS I have given myself a bit of breathing space by rotating the labels to have vertical text, but that will only work for another month or so

[MartinGM]

I found this . . .

Redirecting

. . . which I think I can adapt

[Pecoflyer]

Perhaps this might also help ? Prevent Overlapping Data Labels in Excel Charts - Peltier Tech

[MartinGM]

Thank you - more ammunition for writing a procedure

[Pecoflyer]

Peltier Tech and Andy Pope are great sources for XL graphics