View Single Post
 
Old 06-29-2024, 09:53 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 101
MartinGM is on a distinguished road
Default Fewer data labels ?

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
Reply With Quote