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.

Flip axis or mirror...
 

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

Flip axis or mirror...
 

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