1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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

Discussion in 'Discuss Data Visualizations and Charting' started by marilyn, Feb 20, 2017.

  1. marilyn

    marilyn New Member

    Messages:
    5
    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

    Attached Files:

  2. vletm

    vletm Well-Known Member

    Messages:
    2,805
    ... 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?

    Attached Files:

  3. vletm

    vletm Well-Known Member

    Messages:
    2,805
    @marilyn
    ... and there are rules the way it works
    ... and if 'break' those rules .. it will work as it works ;)
  4. vletm

    vletm Well-Known Member

    Messages:
    2,805
    ... 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?

    Attached Files:

    Thomas Kuriakose likes this.
  5. marilyn

    marilyn New Member

    Messages:
    5
    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.

    Attached Files:

  6. vletm

    vletm Well-Known Member

    Messages:
    2,805
    @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'.

    Attached Files:

  7. vletm

    vletm Well-Known Member

    Messages:
    2,805
    @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?

    Attached Files:

  8. vletm

    vletm Well-Known Member

    Messages:
    2,805
    @marilyn
    ver1 - few modifications
    ver2 - without 15min steps

    Attached Files:

    Thomas Kuriakose likes this.
  9. marilyn

    marilyn New Member

    Messages:
    5
    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?
  10. vletm

    vletm Well-Known Member

    Messages:
    2,805
    The quickest way is:
    from Screen Shot 2017-06-20 at 00.03.07.png to Screen Shot 2017-06-20 at 00.03.27.png
    Those comments tells details of bars.
  11. marilyn

    marilyn New Member

    Messages:
    5
    Now I have a problem - the data was sent to me in a different format and that seems to be causing a 'type mismatch'.

    Attached Files:

  12. vletm

    vletm Well-Known Member

    Messages:
    2,805
    ... 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.

    Attached Files:

    marilyn and Thomas Kuriakose like this.
  13. marilyn

    marilyn New Member

    Messages:
    5
    Thank you, I noticed some of the time spans are not reflected in the chart correctly. I highlighted them. Thanks again

    Attached Files:

  14. vletm

    vletm Well-Known Member

    Messages:
    2,805
    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.

    Attached Files:

    marilyn and sathishsusa like this.

Share This Page