View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Indicate average value to floating bar chart

Hi,

See the previous post, for the basic idea, but since you now want these
figures on all of your bars, I suggest downloading the free XL Chart Labeler
from

http://www.appspro.com/Utilities/ChartLabeler.htm

Then all you need to do is create a colum that gets your Min, Max and Avg
and use the chartlabeler to do the connections.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Guate" wrote:

I've plotted minimum and maximum values (prices) for a number of products on
a floating bar chart, and want to indicate the average price for each product.

Any suggestions? Thanks!