# Thread: Funnel chart (Excel 2000)

1. ## 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. ## 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. ## 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. ## 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
•