Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
lisbeta
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.charting
lisbeta
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 02:48 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"