Excel Chart x-axis label interval with start value offset

[FrisoKoopmanAarding]

Hi everyone,

I got this bar-chart with x-axis labels of which I only want to show every 3rd item, but I also would like to start at the 2nd item of the list.
now I got 1,4,7,10,...
and I like it do show 2,5,8,11, but still chart data from 1, just the label needs an offset of 1.

(VBA solution welcome too)


thanks