Hi,
Would appreciate help on this please using office 365.
I've created a simple chart using time on the x axis and number of occurances on the y axis.
The y axis is simple ranging from 0 to 600. However, the x axis is based on the occurance happening on every second during one day. As such I have 87500 data points. In my dataset I converted the seconds to hours before producing the chart but I can't get the x axis to range from 0 to 24 to show a simple spread over the day. the best I can get is using the auto feature but it uses an unusual interval from 0.0, 0.8,1.6 etc up to 23.5. If I try to amend the intervals manually it appears the maximum interval is 255 which obviously is not high enough to compress 87500 into 24 intervals. This also stops me putting a sensible range of ticks marks on the axis also to visually show the intervals. Really annoying as the odd scale really disrupts the impact of the chart.
Thank you,