Hi, I just noticed my Charts are missing some values labels? I have tried different Data Formats like Number and Same as Source Data but this didn't work?
Any ideas, because it seems to have no problem displaying 7,,7,8,8,9,10,11,11,12 etc on the red line to the left of centre?
Cheers!
MacBook Pro 15″, macOS 12.3
There are a lot more missing values, especially on the left (almost horizontal) part of the red dotted line. It's just a matter of available space.
For a test, duplicate the sheet and stretch the chart in both directions. Reduce the size of the labels font. I bet you'll see more labels after that.
There are a lot more missing values, especially on the left (almost horizontal) part of the red dotted line. It's just a matter of available space.
For a test, duplicate the sheet and stretch the chart in both directions. Reduce the size of the labels font. I bet you'll see more labels after that.
"Reduce the size of the labels font"
Nice one, that fixed it.
I did stretch it horizontally, so as to give it plenty of width but it's not a space issue, it's definitely a font size issue. Phew..
The issue now is the ti have to use Fonts Sizes of 9 in th top chart but the bottom one needs a font size of 8 and the lower line in the bottom chart needs 7.
Any ideas why, when the charts are for all intents and purposes the same dimensions, (with both having 40 rows of price data) I need different font sizes to get all values to show?
I think it must be due to the angle of the slope of the lines on the different graphs.
Chart Missing some Value Labels
