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