Creating Nice visualition chart for dates and hours within year

I do not know what do you mean as 'nice chart'.
Chart is nice until is clearly represents data, imho.

Avoid 3D charts - contrary to what has been said, they do not represent trends as well as a standard 2D chart will do. It's a case of cartoon style over substance.

The second set of data looks very different to the first: I'd have thought you'd have realised by now that over-simplification leads to a lot of time-wasting.

Is this it, or are you going to make further changes?

What is the KEY MESSAGE you want to convey with a chart? This will determine what the best approach is. 'Nice' really doesn't tell us anything.

What do you think the stacked column chart is doing well? What is it failing to show? Have you tried any of the other built in chart types?

I think a line chart would do a better job at communicating how much time was spent on each category, but that's just my opinion. Have you tried a line chart? What did you like about it? What did you not like about it?

To see what a line chart looks like, select your chart and change its type from stacked bar to line ...

There are many built-in chart styles - just go though them individually and play a bit with the options until you find one that suits your purpose.

but i assume that MrShorty has nice idea in order to look this fine.

Ummmmm....Incorrect. My idea was as simple as AliGW suggested -- take the chart in the file in post #3 and do nothing more than change its chart type to 2D line. I am somewhat of a chart minimalist, believing that simple chart types with minimal embellishment work best at communicating whatever I am trying to show.

Pivot tables/charts are useful tools for summarizing data. In this case, I don't see what you want to get our of a pivot table/chart. Suggesting a pivot table/chart indicates to me that maybe you want to further summarize/aggregate the data before charting? Naturally, if you have not yet summarized/aggregated the data you want in the chart, that needs to be done before charting.

Your copy of Excel must be doing something very different from mine, but I obviously cannot tell what it is doing from a picture. When I change the chart type, I get this (you have random numbers, so it isn't exactly the same each time, but you see a normal line chart). I've attached the file, but I still have no explanation for why your copy of Excel gives you something so different.

1) sum of time is not working properly, why?

As near as I can tell, the sum of time is working correctly. I notice that your number formats are all "time of day" formats ("hh:mm") rather than "elapsed time" ("[hh]:mm"), which changes the display. (27 hours means 3 AM, so a time of day format will display 3:00 while an elapsed time format will display 27:00). You might review the guidelines for number formatting time values: https://support.microsoft.com/en-us/...rs=en-us&ad=us

I don't understand your concerns with the stacked line/column chart. The example in your file looks to me like an accurate stacked line chart for the 9 categories. I don't understand what you want the chart to do differently.

I'm still not sure I understand. In the most recent post, you are using a 100% stacked column chart, and it is showing the data as appropriately sized columns stacked on top of each other to make 100%. In your previous post, you showed a 100% stacked line chart that shows each line "stacked" on top of the others to make a total of 100%. Each chart type is doing exactly what you are asking it to do.

As a wild guess, are you thinking of a 100% stacked area chart? Assuming your copy of Excel can handle changing the chart type this time, maybe try changing to a 100% stacked area chart and see if that is what you are looking for.