Advice for type of chart

[Rob]

I'm comparing the sugar content of different beverages.
However the values vary for example cocktails may have
between 90-130 grams per liter and vegetable juices
perhaps 40-100 grams. Which type of graph should I use to
represent the various drinks and show the single
variations rather then their averages?

Thanks,
Rob

 

[Nicky]

Hi
you could try using a "high low close" format, with the "close" value
set equal to the high or low to make it effectively a "high low
chart.

Or, a stacked bar with the first series set to colour none, line colou
none, has a similar effect.

both are illustrated in the attached

Attachment filename: chart data range.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44116