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

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

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

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