Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Superimposing Charts
Hi,
Is it possible to have two charts overlay each other? What I want is to have a stacked bar chart with a count value on the X Axis and on the same chart a bar with a different count value on the other vertical (Z?) axis. Both charts use the same scale on the Y axis This is in XL 2003 if that makes a difference. Hope this makes sense:-)TIA Dave |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Superimposing Charts
You can probably do this with a single chart, changing some series to other
types or moving them to the secondary axis. Without some clarification, though, it's hard to make suggestions. Is this a horizontal bar chart or a vertical bar chart, which in Excel is called a column chart? Once you describe the chart type, it's probably better to refer to vertical and horizontal axes rather than X and Y, because X refers to an independent variable axis, usually horizontal, but for a horizontal bar chart the X axis is vertical. This causes a great deal of confusion. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Hi, Is it possible to have two charts overlay each other? What I want is to have a stacked bar chart with a count value on the X Axis and on the same chart a bar with a different count value on the other vertical (Z?) axis. Both charts use the same scale on the Y axis This is in XL 2003 if that makes a difference. Hope this makes sense:-)TIA Dave |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Superimposing Charts
Jon,
Thanks for the reply. Some clarification: I have a data set Fruit, consisting of: Apple, Pear, Peach. I have a variable, but known number of each fruit (eg, 100 apples, 50 pears, 40 peaches). Each individual fruit is graded 1-3, so of the 100 apples, I might have 45 grade 1, 25 grade 2 and 30 grade 3 and so on for each fruit. Again, the number of each grade is variable but known. I also have a total value for each type of fruit (eg, the 100 apples are worth £150, the 50 pears are worth £100 and the 40 peaches are worth £40) What I had envisaged was a horizontal axis containing Apple, Pear, Peach and each category having two vertical bars, one a stacked bar showing how many of each grade of fruit (the left vertical axis scale) and the other a single bar showing total cost (the right vertical axis scale). I am aware that the cost will be skewed by the total number of fruit, for my actual data this doesn't matter. In reality, I don't care if the data bars are vertical or horizontal. In fact, if there is better way (ie. not using bars) of displaying this data I am more than happy to use it. I've been trying to work out if one of the stock charts might work better, but as I've never used them before I'm struggling a bit. A radar chart sort of works, but it doesn't really show the relationship between the "grades of fruit" and "total cost" that exists with the real data I'm using. Hopefully this makes my goals a bit more clear. TIA Dave "Jon Peltier" wrote: You can probably do this with a single chart, changing some series to other types or moving them to the secondary axis. Without some clarification, though, it's hard to make suggestions. Is this a horizontal bar chart or a vertical bar chart, which in Excel is called a column chart? Once you describe the chart type, it's probably better to refer to vertical and horizontal axes rather than X and Y, because X refers to an independent variable axis, usually horizontal, but for a horizontal bar chart the X axis is vertical. This causes a great deal of confusion. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Hi, Is it possible to have two charts overlay each other? What I want is to have a stacked bar chart with a count value on the X Axis and on the same chart a bar with a different count value on the other vertical (Z?) axis. Both charts use the same scale on the Y axis This is in XL 2003 if that makes a difference. Hope this makes sense:-)TIA Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
superimposing charts | Excel Discussion (Misc queries) | |||
Superimposing graphs | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel |