Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Complex Chart (was Superimposing Charts)
Hi,
Following on from my previous posting... 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 quantity 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 am after is a chart with 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. Any suggestions would be appreciated TIA Dave |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Complex Chart (was Superimposing Charts)
You describe a clustered-stacked column chart: the first stack in the
cluster has three series, the second has one. http://peltiertech.com/Excel/ChartsH...sterStack.html Alternatively (or in addition), since you need a secondary axis anyway, you might find this also useful: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Hi, Following on from my previous posting... 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 quantity 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 am after is a chart with 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. Any suggestions would be appreciated TIA Dave |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Complex Chart (was Superimposing Charts)
Jon,
Thanks for the reply, from what I've been able to read you are absolutely correct. Unfortunately, your site seems to be down at the moment - do you know when it will be up again? Dave "Jon Peltier" wrote: You describe a clustered-stacked column chart: the first stack in the cluster has three series, the second has one. http://peltiertech.com/Excel/ChartsH...sterStack.html Alternatively (or in addition), since you need a secondary axis anyway, you might find this also useful: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Hi, Following on from my previous posting... 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 quantity 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 am after is a chart with 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. Any suggestions would be appreciated TIA Dave |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Complex Chart (was Superimposing Charts)
My hosting provider hasn't even explained to me yet why the site is down.
They've suspended the account, for no reason I can see. I am totally frustrated with them and will not renew (if I even last that long). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Jon, Thanks for the reply, from what I've been able to read you are absolutely correct. Unfortunately, your site seems to be down at the moment - do you know when it will be up again? Dave "Jon Peltier" wrote: You describe a clustered-stacked column chart: the first stack in the cluster has three series, the second has one. http://peltiertech.com/Excel/ChartsH...sterStack.html Alternatively (or in addition), since you need a secondary axis anyway, you might find this also useful: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Risky Dave" wrote in message ... Hi, Following on from my previous posting... 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 quantity 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 am after is a chart with 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. Any suggestions would be appreciated TIA Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Superimposing Charts | Charts and Charting in Excel | |||
superimposing charts | Excel Discussion (Misc queries) | |||
Superimposing graphs | Charts and Charting in Excel | |||
complex chart | Charts and Charting in Excel | |||
HELP WITH CHART - COMPLEX ONE | Charts and Charting in Excel |