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

Discussion in 'Discuss Data Visualizations and Charting' started by muna, Jan 20, 2018.

  1. muna

    muna Member

    Messages:
    52
    Please could someone do a bar chart which shows the following:

    All the figures for additional hours worked. Please note the (minus) represents that less hours were worked than the target deadline. The bar chart in essence will look a line in th middle... Anything under the line is good and anything over is bad.

    High and sub level tasks should be in the same chart

    There should be three charts (one for each team)

    Anything to make the chart look professional, clear and concise.
  2. muna

    muna Member

    Messages:
    52
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    Muna

    Was there meant to be a file attached?

    If not how about a Drawing of what you want ?
  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    I'm sure this isn't what you want ?
    upload_2018-1-20_11-41-6.png

    If it is great

    If not please explain what you are after or draw a picture

    The description about Sub Tasks is confusing as they contain the same values ?
  5. muna

    muna Member

    Messages:
    52
    Omg Hue. I'm going to cry :(

    That's exactly what I want :)

    The data is dummy data and apologies that it has caused confusion. I should have made it easier to understand.

    If you find a better way of presenting such data rather than my initial thought of the line going down and up then do let me know.

    I look forward to your response, either with the method above or something you deem better.
  6. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    See attached

    You can shift the chart where ever you want them

    Attached Files:

  7. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    Hui, isn't it better to show the X- axis labels at the bottom for a cleaner lay-out?
  8. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    My personal preference

    I care about the data
    Not the bling
  9. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    True and I follow: the chart is meant to tell you something about the data. Just asked because of the request "clean and concise". I think it is a bit cleaner like this
    upload_2018-1-20_15-30-49.png
  10. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    If I look at your chart I keep feeling that as I look at a column I Kewp getting drawn back to the left hand axis to look for the zero reference
    Then I can look at the length and value

    In My chart you know where the zero is
    It’s the dates
    So the focus goes to the column value

    Look forward to others comments ?
  11. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    Thank you Hui for sharing your insights and opinion. I've never been great at charting and only show interest in the topic since I discovered Chandoo's blogs a few years back to be honest. I've already learned quite a lot from your guest posts as well.
    Would it then help to highlight the zero value on the y-axis and make the line of the X-axis stand out? Note, I've used red which can be a problem since it often comes with a message on it's own (it is bad).
    upload_2018-1-21_12-54-32.png
  12. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    That pulls your focus back to the data
    I'd still leave the - on the negative numbers
  13. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    Yes, off course the minus is needed. The eye of masters do spot all details.

Share This Page