Chart Min, Max & Average

  • Thread starter Thread starter Guate
  • Start date Start date
G

Guate

I've got pricing data by product, and want to chart the minimum, maximum and
average price for each product. How do I do that?

The product names are long, so I'd prefer to set it up as a horizontal
bar-type chart.

Many thanks!
 
Hi,

You could display a data label with all three values. Because you are using
a Bar you can't use the Line chart type to display these values, something
you could do with a column chart.

="Minimum - "&MIN(B1:B10)&", Average - "&AVERAGE(B1:C10)&", Maximumn -
"&MAX(C1:C10)

You could create a data label for one bar and reference the above formula in
that data label.

To add a single data label - click the series, then single click the bar and
choose Format, Select Data Point, and check Value on the Data Labels tab.

To connect this data label to the formula above, suppose the formula is in
cell E1, single click the data label, then single click it again and on the
Formula Bar type = then click cell E1 and press enter.

You may choose to remove the commas from the formula.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top