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.

Bespoke Excel Graph

Discussion in 'Discuss Data Visualizations and Charting' started by david gabra, Jan 25, 2018.

  1. david gabra

    david gabra Member

    Messages:
    121
    Hi
    I need help to build a graph in excel. It believe is pretty unique and after checking every graph, I did not find a way to do this. Hence I am contacting you for help.

    Please see a printscreen of how the graph should look

    upload_2018-1-25_21-40-34.png


    The x-asix - lets say have company: a, b, c, d, e, f,...
    y axis have amount with 25, gap, eg. 25, 50, 75, 100,........

    Here is the complicated part.
    I need for each company (a, b, c, d) to be able to add:
    a) Cost: high, low and actual and I need to do this TWICE for each company - with two lines with DIFFERENT set of figures, per company
    -
    the actual will the same number in each of the two lines.

    Please refer to a sample excel file with the data

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra - Please refer to a sample excel file with the data
    ... which file?
    ... try to Upload it again
  3. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    796
    Same as Vletm :)
    -> You also tried Boxplot?
    -> Or,... a line chart/column with markers and error bars. I have an example somewhere.
  4. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra
    Your 'sample file' has ... different values than Your 'sample picture'
    also
    Are You sure that Your sample values are 'correct'?
    Are You sure that Your sample data is Okay (is possible to do same kind)?
    .. sample

    Attached Files:

  5. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    796
    Something like this is perhaps suitable for what you want to achieve, but unfortunately I have lost the usb where I had documented the how to. Now I had a bandwidth of standard values with outliers, but the technique seems applicable.
    The technique I learned from Chandeep, who has been an occasional blog writer here. https://www.goodly.co.in/threshold-chart-in-excel/
    upload_2018-1-25_21-29-8.png
  6. david gabra

    david gabra Member

    Messages:
    121
    Hi

    Thanks all so far

    The print screen (made in visio) just to show how I want to present the data - the data are dummy values in the excel are the values I need.

    Please can someone help - so that it will show the values of the max and min and also actual on each bar and remember we need TWO bars for each reference on the x asix.

    Thanks a lot.
  7. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,012
  8. david gabra

    david gabra Member

    Messages:
    121
    Hi Chihiro

    I am using 2016

    I am not being lazy, I saw this site already and tried and tiered in vain for hours to get it to show the max, min and actual for two lines

    Please, I would really appreciate if you could attached a working copy using the excel I attached

    David
  9. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,012
    I ‘ll post it in the morning. Don’t have pc at the moment.
  10. david gabra

    david gabra Member

    Messages:
    121
    Thanks so so much.
    I really appreciate you time effort and assistance. I have tried and with no luck and visio is bad option luck. It is so great have this site as a resource.
  11. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    796
    David, you did already succeed for 1 set of values.
    You can always use a double X-axis. Not really pretty, but perhaps the easiest way. Like this:
    upload_2018-1-26_7-44-23.png

    Attached Files:

  12. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra
    Screen Shot 2018-01-26 at 10.23.27.png
    .. and if something would be missing then ... tell, what is missing?

    Attached Files:

  13. david gabra

    david gabra Member

    Messages:
    121
    Hi,
    Can we get the graph to show the max and minx values too?
  14. david gabra

    david gabra Member

    Messages:
    121
    Hi
    Can we add a max and min number also to the chart?
    thanks
  15. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra ... ouch! ... I didn't show those in original chart
    Screen Shot 2018-01-26 at 13.29.01.png

    Attached Files:

  16. david gabra

    david gabra Member

    Messages:
    121
  17. david gabra

    david gabra Member

    Messages:
    121
    Is it possible to add to the x axis what we see in the printsceen below
    This will really help so I will be clearly able to reference what each line refers to?

    upload_2018-1-26_15-17-22.png
  18. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    796
    Same as Vletm, once more. I think I was really awake this morning. Did just not plot them on the chart.
    Like so?

    Attached Files:

  19. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra
    Many things are possible ...
    and it would be much better if You would know these extra things in the beginning!
    Screen Shot 2018-01-26 at 15.41.14.png

    Attached Files:

  20. david gabra

    david gabra Member

    Messages:
    121
    Perfect!!!!!
  21. david gabra

    david gabra Member

    Messages:
    121
    Hi
    The graph so far is great - I am stuck on one point. The last tweak I need is
    to add a legends per the screenshot below.

    upload_2018-2-5_22-49-11.png

    this is the only legend I need - no others

    thanks

    Attached Files:

  22. vletm

    vletm Excel Ninja

    Messages:
    4,163

    Attached Files:

  23. david gabra

    david gabra Member

    Messages:
    121
    Hi
    that I can do and that does not help me.
    I need only 2 legends -how do I make it so I can remove and only leave 2 that I can have showing red and yellow lines.
    I do not know how to do this
    Please help.
  24. vletm

    vletm Excel Ninja

    Messages:
    4,163
    david gabra
    You can see those two like spots!
    (and others five legends are like 'hidden')

    Attached Files:

  25. david gabra

    david gabra Member

    Messages:
    121
    Much better - how do I change the text of left min max to "before" and the same for the other to "after"

    thanks so so so much

Share This Page