Superimposing Charts

[Risky Dave]

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 senseTIA

Dave

 

[Jon Peltier]

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

 

[Risky Dave]

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