I have a pivot table showing how often a certain "speed" is found in the table.
row labels count of Id
1 31
2 29
3 39
4 66
...
77 2
90 1
92 1
108 8
135 1
This is shown in a pivot chart. The issue: the row labels are treated as text labels instead of number values. As a result: in the chart there is no space between e.g. 92 and 108.
The expected behavior is that there is a space between non-consecutive numbers. This works fine when I create a diagram manually.
To be sure -even though this makes no difference in the manual example- in the data table (and in the pivot table) I have specified that the speed column is of type Number.
Format Axis of the chart has for Axis Type: "automatically select based on data". Also available: Text axis and Date Axis. Not: number. For the manual chart it clearly is treated as numbers, with the option to set minimum and maximum bounds. Using Excel 2016 (Windows).
Any suggestions?