Using Office 365, I created the second type of stacked bar chart using the following data:
10.3 4.133333 0.25 9.316667
The axis marks are automatically set from 0 to 30. On changing the maximum axis point to 24, the minimum axis point changes to -1. Subsequently, on changing the minimum axis point to 0, The axis mark of 24 disappears on the chart.
I am trying to show the above data as constituting a whole of 24 hours. I had considered using a pie chart, but I would rather use a stacked bar graph as it represents the linear nature of time well (good visual representation).
If there is some other type of chart that can suits the purpose, I would gladly accept it. Otherwise, how can I tweak this specific bar chart so that the values are represented from 0 to 24.