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.

Making a bar graph with dummy column in Excel

Discussion in 'Discuss Data Visualizations and Charting' started by OSK, Aug 4, 2018.

  1. OSK

    OSK New Member

    Messages:
    13
    I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. from what i searched, i found out i have to make dummy columns but I cant figure out how to make it in excel. If someone can explain, it will be helpful. Thanks (link to sample data in excel file is attached).
    IMG_20180803_125729.jpg

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,671
    I'm not really sure what you mean by a Dummy Column ?

    Do you want this?
    upload_2018-8-5_12-26-39.png

    or format as required
    upload_2018-8-5_12-28-25.png
    Thomas Kuriakose likes this.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,671
    upload_2018-8-5_12-31-36.png

    see attached file

    Attached Files:

    Thomas Kuriakose likes this.
  4. OSK

    OSK New Member

    Messages:
    13
    Hello Hui
    Thanks for the answer, but i need to y axis as MW and the height of each bar should show MW. E.g if the MW of 1 turbine is more the height would be more if MW is low the height would be low. And on x axis it should show the exact operating hours. Like for the most operating turbine its 8170 but in graph it shows 26000. Have a look at the pic i attached. The y axis in it and how the heights of bars are changing with the value.

    Best
  5. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    Could You upload same year data as in Your graph?
  6. OSK

    OSK New Member

    Messages:
    13
    Hi vletm,
    I dont have that data. Thats uploaded just for example.
  7. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    Your data has 'more rows'.
    If You would like to see both x & y-axis widths&heights as in Your sample.
    So far, challenge with bar-graph (for me) ...
    but if could use other way then something like in this file.
    If really with bars, then it's also would be possible ...
    but then I need to know exact what would be fixed per every 'year'.
    (= datas layout have to be same, as well as 'graph's position on sheet ).

    Attached Files:

  8. OSK

    OSK New Member

    Messages:
    13
  9. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    Did You mean this?
    Screen Shot 2018-08-05 at 14.35.30.png
    but in Your case
    Alpha should be show only above ~75
    Beta x0 & y>~50
    Gamma x0 & y> ~25
    Delta x0 & y ~25
    If compare this to You sample graph or how?
  10. OSK

    OSK New Member

    Messages:
    13
    no i meant this graph. someone asked a question in comments and asked how to make it. find it in comments. one person explained how to make it. but i cant make it work.



    upload_2018-8-5_13-45-4.png
  11. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    Your original 'want' is basic like below, not as Your previous!
    Screen Shot 2018-08-05 at 14.51.13.png
  12. OSK

    OSK New Member

    Messages:
    13
    yes exactly, where the length of the bars (x axis) show hrs and height (y axis) shows MW
  13. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    If You 'like to get' as in my #11 then there are few challenges
    which You could see in my #7 sample.
    There would need 'a lot of dummy columns' ... or
    do it other way!
  14. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK
    Your sample data look like this ...
    Screen Shot 2018-08-05 at 16.36.25.png but texts ... hmm?
    There are lot of texts in Your sample.
    Ideas?

    Attached Files:

  15. OSK

    OSK New Member

    Messages:
    13
    yes great, we can put it as legend and show which color represents what. can you explain a little bit how you made this. Thanks
  16. vletm

    vletm Excel Ninja

    Messages:
    4,429
    OSK ... oops! ... this reply was still here :(
    I moved that 'box' ... better place.
    Now, there are colors, texts, values 'like legend'.
    It is made 'box-by-box' ;)
    ... add some 'features'

    Attached Files:

  17. OSK

    OSK New Member

    Messages:
    13
    Vletm
    Thank you very much for your help. i really appreciate it
  18. p45cal

    p45cal Well-Known Member

    Messages:
    1,247
    AAre my eyes deceiving me?
    Is there 'bleeding' at the red arrow:
    upload_2018-8-6_11-22-20.png
  19. OSK

    OSK New Member

    Messages:
    13
    I am not sure. couldnt be. maybe someone traced the line with a pen or something
  20. p45cal

    p45cal Well-Known Member

    Messages:
    1,247
    The more I look the more I think it's meant to be there; it even has its own label.
    This suggests to me a stacked bar chart with very thin bars.

Share This Page