Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combining two charts into one
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Penny -
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. Your guess is correct. 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? You will have to build your own dummy axis: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ |
#5
|
|||
|
|||
I am having serious trouble following the arbitrary axis while using the
tornado chart. Any specific examples using the data from the tornado chart webpage? Thanks, Penny "Jon Peltier" wrote: Penny - 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. Your guess is correct. 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? You will have to build your own dummy axis: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
combing two bar charts to share one axis | Charts and Charting in Excel | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
To get a lot of charts that contain different values in a minute | Charts and Charting in Excel | |||
pie charts - how to include "zero" fields on Legends | Charts and Charting in Excel |