If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
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 | 1 | October 19th, 2005 08:42 AM |
Problem with the display of a 2 axis chart | Peter B | Charts and Charting | 1 | August 4th, 2004 02:39 AM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
Two Y axis with different scales for a line chart | vacaut | Charts and Charting | 3 | October 30th, 2003 01:36 PM |
Logarithmic X Axis in PivotChart. | Nashhol | Charts and Charting | 0 | October 21st, 2003 04:39 PM |