Flip axis or mirror...

How do I make a chart where

A B
X 3 5
Y 7 12
Z 15 20

the numbers below A shows on the left side of the axis and the numbers below
B shows on the right side of the axis.

Sort of like when you look at charts that shows age and gender distribution
in a country - these charts usually have the shape of a christmas tree.

Hi,

Also know as tornado or pyramid charts.
See these examples.
http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/softwa...ado/index.html

Cheers
Andy

lisbeta wrote:
> How do I make a chart where
>
> A B
> X 3 5
> Y 7 12
> Z 15 20
>
> the numbers below A shows on the left side of the axis and the numbers below
> B shows on the right side of the axis.
>
> Sort of like when you look at charts that shows age and gender distribution
> in a country - these charts usually have the shape of a christmas tree.

--

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

Super duper!!! I didn't know that the name of these were tornado charts.

Thank you very much

"Andy Pope" skrev:

> Hi,
>
> Also know as tornado or pyramid charts.
> See these examples.
> http://peltiertech.com/Excel/Charts/tornadochart.html
> http://tushar-mehta.com/excel/softwa...ado/index.html
>
> Cheers
> Andy
>
> lisbeta wrote:
> > How do I make a chart where
> >
> > A B
> > X 3 5
> > Y 7 12
> > Z 15 20
> >
> > the numbers below A shows on the left side of the axis and the numbers below
> > B shows on the right side of the axis.
> >
> > Sort of like when you look at charts that shows age and gender distribution
> > in a country - these charts usually have the shape of a christmas tree.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>