Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Funnel chart (Excel 2000)

    I am trying to produce a chart to appear in a funnel format. It is using 3 sets of data, plotting 2 on the x-axis (average gain and loss) and 1 on the y-axis (standard deviation). When the chart is created it should appear that those entires with the biggest gains and losses are at the top, therefore having a higher standard deviation and the funnel effect will be created downwards. I can only plot the two sets of data on the x-axis and cannot work out how to make excel read the 3rd set of data (spreadsheet attached).

  2. #2
    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: Funnel chart (Excel 2000)

    I am not sure what you are trying to plot and how. Could you elaborate?

    I am not sure whay you mean by "funnel format" are you perhaps speaking of a "tornado chart", see Jon Peltier at his site for info.

    Also if the Y will be std deviation, then the ones with the highest std deviation will be at the top, X is the dependent axis (on the bottom) so ones with highest gains will be on the right.

    Steve

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Funnel chart (Excel 2000)

    Yes, it is a tornado chart. But I need the y-axis to show the St Dev and plot the points along this axis according to this value rather than just plotting the points in a series.

    Does this make more sense?

    Sarah

  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: Funnel chart (Excel 2000)

    You mean like this?

    Steve

Posting Permissions

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