Excel Bar Chart Help

[Notthekingofexcel]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product
[/TD]
[TD]Min
[/TD]
[TD]Median
[/TD]
[TD]Max
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]1.00
[/TD]
[TD]5.00
[/TD]
[TD]7.00
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]2.00
[/TD]
[TD]4.00
[/TD]
[TD]6.00
[/TD]
[/TR]
[TR]
[TD]Pear
[/TD]
[TD]0.50
[/TD]
[TD]3.00
[/TD]
[TD]7.00
[/TD]
[/TR]
[TR]
[TD]Bread
[/TD]
[TD]1.00
[/TD]
[TD]2.00
[/TD]
[TD]3.00
[/TD]
[/TR]
[TR]
[TD]Croissant
[/TD]
[TD]0.50
[/TD]
[TD]0.50
[/TD]
[TD]0.75
[/TD]
[/TR]
[TR]
[TD]Scone
[/TD]
[TD]0.25
[/TD]
[TD]0.40
[/TD]
[TD]0.8
[/TD]
[/TR]
[TR]
[TD]Lettuce
[/TD]
[TD]2.00
[/TD]
[TD]2.25
[/TD]
[TD]2.60
[/TD]
[/TR]
[TR]
[TD]Cabbage
[/TD]
[TD]3.00
[/TD]
[TD]3.20
[/TD]
[TD]3.40
[/TD]
[/TR]
</tbody>[/TABLE]
Hi,

This maybe a basic question. I am trying to create a bar chart which has the price of a unit Min Max and Median. This bit I can do.

A example of my data is above. What I want to be able to do is have them grouped (E.g. Fruit, Salad, Baking) but still have separate bars.

Thanks in Advance

 

[oldbrewer]

add a new column 1 with food category, ie fruit salad baking then sort whole table by new column A
this will group them together for you

if I understand the question, you want a chart with say fruit as one of the x-axis labels and above it three min median max for apple orange pear ???