hi,
I am trying to use a stacked column chart to show the amount of hours required, depending on assembly time, on a day of the week. The data in my table is custom formatted for time as 'hh:mm:ss'.
The x axis is the days of the week, the y axis is the total hours required and the stacked comlumns are the different assembly types.
The problem i am having is that the y axis goes up to 23:00:00 then reverts back to 00:00:00. I want the y axis to just simply count from 0-48, in increments of 1 as this is a cumulative total of hours required by a whole production department, there will always be more than 24 hours woork on any given day.
But i would also like the y axis to know that it is counting in hours, so that, if a assembly time is 1.5 hours, the stacked column fills upto 1.5 on the y axis, and if the next assembly process also takes 1.5 hours, the two combined will fill the chart upto 3 on the y axis.
I hope there is someone who can help me with this.
Thank you in advance
Bookmarks