• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

bar chart with duration of an event against time of day

marilyn

New Member
I was given data and instructed to provide a bar chart showing duration of an event against hours of the day. Each bar should be colored to match the location of the event. It was being completed manually by the prior employee. I attached a sample of the data (anonymized) as well as what the chart should look like. Thank you
 

Attachments

  • for chandoo.xlsx
    40.6 KB · Views: 13
  • chandoo data.xlsx
    19.1 KB · Views: 13
... just noticed this
... do You still miss this?
I copied that 'Dec2016' data and did something...
There is [Do It]-button, press it!
> Ideas ... Questions?
 

Attachments

  • marilyn.xlsb
    56.3 KB · Views: 11
... few modifications and
hint:
If need to see other months data,
1) delete old data from Sheet1 ( not 1st row )
2) copy new data to Sheet1 as original data!
... it seems that dates and times has saved as text!
3) if over midnight data would like to see
... just let me know - okay?
 

Attachments

  • marilyn.xlsb
    57 KB · Views: 12
... few modifications and
hint:
If need to see other months data,
1) delete old data from Sheet1 ( not 1st row )
2) copy new data to Sheet1 as original data!
... it seems that dates and times has saved as text!
3) if over midnight data would like to see
... just let me know - okay?

wow, this is amazing. I wish I knew how to do this -
I have been traveling so my apologies for not responding sooner.
I will need to show data over midnight.

I also have another request :)

Is it possible to add the initials as shown on the chart on Jan 3?

thank you very very much.
 

Attachments

  • Copy of chandoo data 2.xlsx
    18.9 KB · Views: 3
  • Copy of for chandoo 2.xlsx
    37.4 KB · Views: 3
@marilyn
... I gotta do that 'overnight' later,
but the initials could show like this file.
If shorter than 30min durations then ... challenge!
Those takes two cells!
If really needs to turn initials then
... smaller letters or those needs '45min'.
 

Attachments

  • marilyn.xlsb
    81.4 KB · Views: 6
@marilyn
with 'over midnight' version.
1) There are ... something ... with Your formulas,
but no matter for 'bar chart' (not use those values).
2) That 15min steps would make some overlaps,
but of course those could do ex 1min steps too.
> Ideas ... questions?
 

Attachments

  • marilyn.xlsb
    83.3 KB · Views: 7
Thank you immensely for this, it is amazing. In version 1, how do I delete the red mark (comments/notes) that are on every bar?
 
Now I have a problem - the data was sent to me in a different format and that seems to be causing a 'type mismatch'.
 

Attachments

  • to Chandoo Marilyn 09 08 2017.xlsb
    81.2 KB · Views: 4
... Houston ... we have a problem ... Yes!
Data have to be in correct/same format!
... now, it's a little slower
... because, it have to solve those formats.
 

Attachments

  • marilyn.xlsb
    121 KB · Views: 4
Thank you, I noticed some of the time spans are not reflected in the chart correctly. I highlighted them. Thanks again
 

Attachments

  • marilyn Chandoo August sample.xlsb
    122.1 KB · Views: 1
Yes ... hmm ... Yes
Middays are something ...
There are some challenges to 'understand' some times...
I added one second to every timestamp and
it seems to look better - or how?
Screen Shot 2017-09-19 at 10.48.23.png
There were marked one overnight too - isn't that look correct?
The last part (after midnight) is next days early-early morning.
 

Attachments

  • marilyn Chandoo August sample.xlsb
    121.2 KB · Views: 9
Back
Top