Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2006
    Location
    Bury St Edmunds, Suffolk, United Kingdom
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Christmas tree graph (2000)

    Does anyone know how to create or modify a stacked bar chart to look like the christmas tree style charts

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Christmas tree graph (2000)

    Welcome to Woody's Lounge!

    Can you explain what you mean by a "christmas tree style chart"?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Christmas tree graph (2000)

    Are you talking about a "stacked cone" or "stacked pyramid"? Those are both chart types on Step 1 of the Chart Wizard (at the very bottom).

    Satiria

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Christmas tree graph (2000)

    Are you speaking about essentially "inverted" Tornado Charts?

    Steve

  5. #5
    New Lounger
    Join Date
    Jan 2006
    Location
    Bury St Edmunds, Suffolk, United Kingdom
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Christmas tree graph (2000)

    Very similar to that Steve see my stacked graph, what i want to do is get all the bars centered, giving a 'Christmas Tree' effect

  6. #6
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Christmas tree graph (2000)

    Hi taclar

    You don't work for the NHS by any chance do you? <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> We use "Christmas Tree" graphs pretty frequently - the best way of achieving the desired result is to have another set of your workforce data, but made negative (i.e. 0 - [data]). You then need to plot both sets of data on the same axes to produce the desired effect.

    There are a number of models already available to save you the effort though...

    Service Reconfiguration Using Christmas Trees on the National Healthcare Workforce Portal contains a handy tool.

    Alternatively, try emailing Dave Waghorn, whoever he is. Apparently he's a software developer for Hampshire and Isle of Wight Workforce Development Directorate and a data modeller for the Workforce Review Team; he might just have a number of other tools you might like to try. <img src=/S/hushmouth.gif border=0 alt=hushmouth width=16 height=16> <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

  7. #7
    New Lounger
    Join Date
    Jan 2006
    Location
    Bury St Edmunds, Suffolk, United Kingdom
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Christmas tree graph (2000)

    How did you guess!!!!!
    Thank you so much for your help, its been driving me mad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •