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.

How to create a graph for Executive Out time

Discussion in 'Discuss Data Visualizations and Charting' started by Prasad L V A, Aug 10, 2018.

  1. Prasad L V A

    Prasad L V A New Member

    Messages:
    5
    Hi, I am looking for help as how to create a graph to showcase the Executive Out time Target Vs Actuals (Day wise).

    Attached sample file.

    Help would be appreciated.

    Best

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,667
    Prasad

    firstly, Welcome to the Chandoo.org Forums

    How about this?
    upload_2018-8-10_19-21-17.png

    See attached file:

    Attached Files:

  3. Prasad L V A

    Prasad L V A New Member

    Messages:
    5
    It is just fantastic.
  4. Prasad L V A

    Prasad L V A New Member

    Messages:
    5
    Hi Hui, It would be of great help if you can explain the logic in the formula & the chart. I have some other months data to be done.
  5. Prasad L V A

    Prasad L V A New Member

    Messages:
    5
    Hi Hui, If you could help pl?
  6. Prasad L V A

    Prasad L V A New Member

    Messages:
    5
    Hi Hui, You should be a busy man. Trying to grab your attention from last 10 days. It would be of great help if you can spare some time and help with logic of the formula & Chart. I have attached the sample file with all 4 months data. Really would appreciate your help...

    Attached Files:

  7. vletm

    vletm Excel Ninja

    Messages:
    4,415
    Prasad L V A
    You could do those like this ...
    (Modify needed times to columns D, E, F & G as in samples
    ... some of those AM/PM looks... hmm?)

    Attached Files:

  8. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,667
    I have become snowed under and am sorry I won't get to this for a little bit
    I am also working on a new Excel project which I want to publish soon.
    It will blow your mind. It has blown my mind and I wrote it

    The chart

    There are 2 sets of stacked column charts
    1 set for each vertical axis

    The first series in each set is the start time and it is shaded with no fill, but if click below each Colored bar it will be highlighted

    The second series, the colored column is the length of time

    Click on each series and look at the source range for the series in the Formula Bar

    Then follow the formula to see where they came from
  9. RedHotSun

    RedHotSun New Member

    Messages:
    3
    I guess the Graph should more like the one in attached file.

    Attached Files:

  10. vletm

    vletm Excel Ninja

    Messages:
    4,415
    RedHotSun
    ... You used Hui's layout.
    The graph would look as Your given data
    (as I tried to write too in my sample).
    ps. #9 Reply uses some formulas which don't work with me;
    That's why, for me, there are many not valid values.
  11. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,667
    The two vertical axis in my original post have different vertical scales, so it is distorted a little

Share This Page