Excel Bar Chart Help

[Notthekingofexcel]

Product	Min	Median	Max
Apple	1.00	5.00	7.00
Orange	2.00	4.00	6.00
Pear	0.50	3.00	7.00
Bread	1.00	2.00	3.00
Croissant	0.50	0.50	0.75
Scone	0.25	0.40	0.8
Lettuce	2.00	2.25	2.60
Cabbage	3.00	3.20	3.40

<tbody>
</tbody>

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 ???