Grouping data for a chart

[cm80]

Hi,

I have something like the following series of data.

A Apples 5
b. Oranges 10
c. Pears 5
d. Oranges 5
e. Pears 10
f. Oranges 5

However, I want to create a chart so that it groups the data and represents it as follows.

Apples 5
Oranges 20
Pears 15

Is this possible with Excel? I want it all in just one chart

Any help would be much appreciated please.
Thanks,

 

[xlbo]

Use a pivot table to group the data and create the chart from that Rgds
~Geoff~