Competition Help! Rabbits!!! . . . . *and excel

Discussion in 'The Front Room' started by Scouse, Nov 9, 2018.

  1. Scouse

    Scouse HERO! FH Subscriber

    OK - so struggling to do this.

    I've a dataset, as represented below. I want to show the numbers in January and the numbers in december side-by-side in graph format.

    I then want to show the increase (added by shagging) on TOP of the december numbers (or as a proportion thereof) - in a two-tone bar - as mocked up in mspaint on the right.

    The three-column graph is no use to me. I need to show two columns, with the second columns numbers (december) indicating what the difference is added by shagging.



    If it *cannot* be done, how do I represent this in a similar, but logical and easy to understand way?
  2. caLLous

    caLLous I am a FH squatter

    Could you not cheat and compose the second chart of "December + the increase" rather than "January including the increase"? I've no idea about Excel, I could probably do it in matplotlib.

    (Your neighbour needs to have a word)

    (I think you have December and January the wrong way round)
  3. Scouse

    Scouse HERO! FH Subscriber

    Jan>Dec are the right way round - show an increase. I'd like to be able to visually show that increase (or decrease, in the case of death by pie).

    Manual is a pain. Too much data.
  4. dysfunction

    dysfunction FH is my second home

    Why use a stupid graph where the table tells the story much clearer.

    Do you ever see a graph for the football league tables??
  5. Job

    Job The Carl Pilkington of Freddyshouse

    I used to very good with paint shop pro and made most of the graphs for the office, fuck using excel..its frickin painful.
    • Facepalm Facepalm x 2
  6. caLLous

    caLLous I am a FH squatter

    Somebody has never worked with large datasets before.

    Why are you even showing January if you can looked at the December (including the change) and work January out from that? Why don't you just do a single stacked bar for each location?
  7. Job

    Job The Carl Pilkington of Freddyshouse

    No..just 500K subscriber data base, you know real stuff, not trends.
  8. caLLous

    caLLous I am a FH squatter

    Cool, let's see one of the graphs you did in Paint Shop Pro then.
  9. Job

    Job The Carl Pilkington of Freddyshouse

    Oh yes I archived them all and keep them safe on a thumbdrive in a locket around my neck.
  10. Scouse

    Scouse HERO! FH Subscriber

    Don't lie Job. We all know you can't use a thumb drive.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.