R
Risky Dave
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
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