Thanks - that is helpful. Two more questions...

1. Do the rows have to total 35? I am guessing they could total to
anything as long as they were the same in each row.

2. I like having the separation between the two sets of categories (one
jetting to the left and one to the right). However, I also need the X axis
to be shown. With the 100%stacked bar chart, the axis become percentages. I
lose the numbers. Any help here?

Thanks, Penny

"John Mansfield" wrote:

Penny,

The important things to note about Jon's example a

(1) It is based on a 100% Stacked Bar Chart.
(2) The totals of each of the groups = 35.
(3) You need to work with numbers that add up to 35.

There are five series. The second and fourth series are given. The middle
series consists of the number 7. Since the middle series is used for spacing
only, the number 7 could be 8, 9, 10, 4, 3, etc. As you increase or decrease
that number the middle spacing will change. The only restriction is that
each point in this series must be exactly the same so that the tornado has a
vertical inside left and right borders.

The numbers for the first and fifth series are plugs to get the groups to
equal 35. The numbers in these series will need to be worked with so that
the outside left and right borders of the tornado chart are vertical.

Hope this helps.

----
Regards,
John Mansfield
http://www.pdbook.com
"Penny" wrote:

The tornado chart on Peltiertech's website is somewhat useful. I do not
understand, however, from where the numbers come to put in the "dummy"
series.

Thanks in advance.
Penny


"Andy Pope" wrote:

Hi Penny,

I think your description of jetting left and right fits that of a
tornado chart. Check Jon's example.
http://peltiertech.com/Excel/Charts/tornadochart.html

Cheers
Andy

Penny wrote:
My data is organized into three columns (e.g., column A represents a
category, column B represents a frequency for each category and Column C
represents another frequency for each category). I first created two bar
charts such that the Y axis represented categories (i.e., -5 to 5, 5 to 15,
15 to 20, etc) and the X axis represented frequency 0 to 100.

I would like to have one bar chart so that the two charts above share a
common Y (categories) axis. I would then like the frequency for the data in
Column A to jet off to the Right and the frequency for the data in Column B
to jet off to the Left.

Any suggestions? Thanks in advance.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info